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.

       

      Thanks!

       

      Jamie

       

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