3 Replies Latest reply on Aug 14, 2018 8:02 AM by Joe Oppelt

    Four Week Average Calculation w/out Showing Date Variable

    jamie fay

      Hi guys,


      I have been trying to calculate the 4WA without showing the date in my worksheet.  I have a summary page showing high level KPIs, but I want to add context by comparing them to the 4WA.  I can produce the table calc.s and window_sum() versions, but neither give me what I need.


      I only want to show, let say sales and the delta to the 4WA.  Any help would be great.






      Ps. I'm in work and would get clobbered by IT security if I uploaded an example workbook, sorry!