1 Reply Latest reply on Oct 23, 2018 1:42 AM by Hideki OGAWA

    Weekly Sum Then Average Except Last Month

    miltoncaluya

      How do I achieve this kind of calculation in Tableau?

       

      I have an aggregated Weekly sales then I need to average the first 4 weeks so I could compare it with Week 5. I think I only got the first one which is the current view, I can't figure out how to reach the desired view.

       

      Thanks!

       

      Current

       

      {FIXED [Week] : SUM([Value])}

       

      WeekValue
      110
      210
      320
      420
      550

       

       

      Desired

       

      WeekValue
      1-415
      550