2 Replies Latest reply on May 8, 2018 7:35 AM by Rose K

    Calculation For LTM and Current Month

    Rose K

      I have a side-by-side report where one shows Last 12 months and one bar shows current month data. So, In my case Current month means data before 2 months.,So, the Last latest month in the DB would be March(as it is May now) and this should be shown as current month bar and for LTM the  April 2017 to March 2018. Is there a way we could show this by writing a calculated field.

       

       

      And the other case is, in the x-axis we see(0.9 and etc) so, That is a also a measure. But by default we just need to show the count of the current month which again is March for both LTM as well as Current month. Is there a way we could achieve this.

       

      I have attached a sample workbook. ANy suggestions would work.

       

      Thank You