I would like to calculate the unit price per customer for each sales date.
If you add up the number of customers for each sales date and store with function ‘maxOver’ as shown below, it will be a strange number.
sum(Sales) / sum(maxOver(Number of customers,[Sales date, Store], PRE_AGG))
I would like to aggregate it like the attached image. Is there a way to realize it?