Hi,
attached the superstore data. I want to aggregate sales for the sheet per parameter1(1 to 30),lets say for every 5 days(calculate sum of sales for 5 days then next 5 days etc). I tried by table calculations, but stuck in calculating the aggregate for a definite number of days as per parameter1. I could calculate the moving total which calculates first 5, then for the next entry previous 5 etc..but i want one entry for first 5, then next 5 and so on(when parameter1 is 5). Can somebody please point out how to do. It should also include those days where sales is 0, ie if the day is not listed(although the scenario is not present here).
Best Regards,
Sudip
Hi Sudip,
This could be done using fixed-size
(Parameter driven) calculated Bins.
Please find the attached as an example.
Yours,
Yuri