27 Replies Latest reply: Mar 26, 2018 3:06 AM by Ramkumar Manickam RSS

    Rolling 12Months for Sales in Bar Chart

    Ramkumar Manickam

      Hello Team,

      I am trying to show only last 12 months Total_Expense measure value in bar chart... X-Axis = YYYYMM & Y-Axis= Sum of Total Expense.

       

      I am using Sum(TOTAL_EXPENSE) expression in measure value..


      Format is YYYYMM, which data used to.

       

      Can any one help me find out expression which i can use for last 12 rolling months in the bar chart..

       

      Untitled.png