6 Replies Latest reply on Aug 21, 2015 12:39 AM by Anshul Gupta

    Calculate last 12 months data according to selected month

    Anshul Gupta

      Hi All,

       

      I am stuck in a query where I have to calculate last 12 months of data on selected month, the data is of below kind:

       

      MonthDataLast 12 Month Sum
      January978
      February1045
      March554
      April224
      May145
      June578
      July964
      August475
      September1270
      October368
      November569
      December873

       

      December data is consist of January to December sum of Data column, same for any other month. Data contains various years. How this can be done in tableau.

      Please help!!!

       

      Thanks,

      Anshul