1 Reply Latest reply on Oct 16, 2018 3:02 PM by Yuriy Fal

    how to calculate total of custom number of days as per parameter

    sudip midya

      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