0 Replies Latest reply: Jan 10, 2017 1:45 AM by Arun Kumar RSS

    Aggregate average of previous quarter for the selected month

    Arun Kumar

      Hello All,

       

      I have filters like FiscalYear(2016-17) & FiscalMonth(Apr to Mar), I need to calculate the aggregated average value for dimension of the previous completed quarter on the month selection

       

      Ex: suppose as a user I have selected Sep as FiscalMonth in my filter, I have to get the aggregated value for quarter of (Apr-Jun)

       

      Hope you understood.

       

      Thanks in advance,

      Arun