1 Reply Latest reply on Jan 13, 2019 8:46 AM by Shinichiro Murakami

    How to Calculate Current Quarter Sales, Previous Quarter Sales and Previous year Quarter Sales.

    vibin.venugopal.0

      Hi All,

       

      How to Calculate Current Quarter Sales, Previous Quarter Sales and Previous Quarter Sales.

      I tried many options , solutions given in the tableau forums but it doesn't seems to work.

       

      I want the product and Sub category in the rows and then Current Quarter sales, Previous Qaurter sales and Previous year same quarter sales.

       

      I have twp filter one for year and one for quarter.

       

      If user selects year  - 2018 and quarter  - Q4 the report should show current quarter value ie 2018Q4 and previous quarter value ie 2018Q3 and previous year quarter value ie 2017Q4.

       

      Kindly help. Attached the workbook.