9 Replies Latest reply on Jul 8, 2017 9:50 AM by khalida nihal

    Calculate last 1 year data in tableau

    khalida nihal

      Hello All,

       

      I am trying to fetch the last one year data in tableau from the month in which the report is run. For Example, If I run the report on July 2017  then the report should portray "July 2016 -  July 2017" data.   I have attached sample data in the excel. I need to represent below 2 reports in graphs:

       

      • When ledger='AA' represent past 1 year data for POH and SGA
      • When ledger ='AA' represent past 1 year data for GM %age of Revenue.

       

      GM %age of revenue is a calculated field. Please find attached the workbook as well which shows these values. Please help me  to resolve this.

       

      Thank you