1 Reply Latest reply on Jan 23, 2019 2:07 PM by Jim Dehner

    12 months of Sales running totals for current and past years

    shivam negi

      Hello Guys,

       

      I am trying to find out how to create a column which can give me running totals for last 12 months for each month.

      So basically, for January 2019- it should give me total for each of the 'Sales' element from 'January 2018 to January 2019'.

      for Feb 2019- it should give me total for each of the 'Sales' element from 'Feb 2018 to Feb 2019'.

       

      Capture.PNG

       

      Currently Sales are adding up in 'Sales 12 months till now column, but its not the way I want.

        • 1. Re: 12 months of Sales running totals for current and past years
          Jim Dehner

          Good afternoon

          you have most likely filtered out the prior year so it is not in the data on the table that underlies the viz - you would need to include 24 months of data to get the running total the way you want it

          one way to solve the problem is to build the table based on 24 months Or mre depending on how fart out you want to go - then create and Idex() going down the table and hide the first 12 months - they will still be in the underlying table but not vizable

           

          Jim