2 Replies Latest reply on Sep 10, 2018 1:59 AM by Debayan Karmohapatra

    Previous Year/Quarter/Month differences calculation

    Debayan  Karmohapatra

      Hi,

       

      I have a requirement to show the previous measure values of a year, quarter and month.

      My question is similar to this question: https://community.tableau.com/message/816046?et=watches.email.thread#816046

      However lookup give the previous row values instead of previous period value.

       

      For example FY2017 Q1 should give me FY2016 Q4 value. If the previous period is missing it should show 0 or Null.

       

       


       

       

       

       

      Similar effects should be for  Month and Year. For example for month FY2017 NOV should give FY2017 OCT value. If the previous period is missing it should give 0 or null.

       

       


       

      Here the Quarters are not calculated as per gregorian calendar, ie it may not start with Jan and so on, it might start from July or September depending on different countries