6 Replies Latest reply on Oct 3, 2017 12:16 PM by Nandhakumar Ramanathan

    Last 12 Month Measure Calculation for a given month


      Hello Tableau Community,


      I'm new to Tableau and I have difficulty in calculating last 12 months sales for a given Order Date Month.


      Attached is the workbook, I'm pulling last 6 months of Order Date and I want my sheet to display Sales for given Month of Order Date and Last 12 Months and Previous Year Last 12 Months.


      I created couple of Calculated fields to pull the required data and I can understand why they're not working correctly but I can't figure out how to make them return correct information.

      For Example:


      If Month(OrderDate) is November 2016,

      (1) I want SUM(Sales) for November 2016

      (2) I want SUM(Sales) from Dec-2015 to Nov 2016

      (3) I want SUM(Sales) from Dec 2014 to Nov 2015


      This should all display on single row for last 6 Months.