Total number of guests

[AdilFS]

For my restaurant I need to calculate the UPT = Units sold * 1000/Total Guest count for the period

I have visualisation with division by product and it gives me guest count by product, therefore the formula is calculated incorrectly. For this formula i only need Total Guest count for the period. How do i do it?

[Mahesh0016]

@AdilFS Please Share your Expected OutPut and dummy data.

[AdilFS]

I expect it to give me a table like this one

But it calculates Guest Count for each product separately, while i only want the total number for the period