2 Replies Latest reply on Aug 29, 2016 10:05 PM by Pushpendra Nabh Tripathi

    current month and 6 previous month calculation

    tanya.kanwar.0

      Hi,

       

      I have 8 months data available starting from Oct 2015 to Mar 2016.  In my dashboard, I will have Fiscal month filter, that should point to Mar by default.

      I have to analyse my sales data, then my dashboard should give me this value

                     Current Month                                          Last Months

      Sales        134(current month march)                     560(this value should be sales from oct 2015 to Feb 2016)

       

      if I change Fiscal month to Jan

                     Current Month                                          Last Months

      Sales        45(current month Jan)                           320(this value should be sales from oct 2015 to dec 2015)

       

      How do i do this ? Pls help..

       

      Thanks !