Hey,
I'd like to create KPI (single value) that shows me the average sales per week over the quarter.
Let's say I have the following data:
where weekly average is simply sum(sales value) over 7 days divided by 7.
Quarterly average is given by the formula in spreadsheet (attached).
In result on worksheet I'd like to have only the single final value for the current day. In the example above it's '498'.
Is there anybody to help?
Thanks a lot in advance!
Is it possible with the use of table calcs?