5 Replies Latest reply on Sep 28, 2019 3:03 PM by Francisco Sanchez

    Show last 12 months total from selected date

    Francisco Sanchez



      I hope somebody can help.


      I have been trying to show a 12 month total.  (Select month and year in the filters and return the totals from that date to the previous 12 months.).


      Example: In the screenshot I have selected December 2015.

      So in the chart, I am trying to display the total from December 2014 to December 2015.  (1 column not monthly values)


      If I choose in the filters November 2015.  The total in the chart would be the November 2014 to November 2015.



      Have looked at many other posts but no luck.  I might be thinking I need an LOD expression for part of the calculation.  But not sure.


      I am using version: 2019.1.7