1 Reply Latest reply on Oct 4, 2018 10:06 PM by meenu choudhary

    Find a Max, Min and Average value for any selected dimension

    Nagaraj Koranthota

      Hi,

       

      I am trying to find Max, Min and Average value within last 12 Months.

      Let say in below example

      Sub Product , Product, BU, Abc, Xyz are my different dimensions at different granularity

      if I have all of the above dimensions as filters, I should be able to get MAX, MIN, AVG $$ value in the Last 12 Months.

         

         

      MonthSub ProductProductBU$$XyzAbc
      1A1AAB100
      2A2AAB101
      3A3AAB102
      4A4AAB103
      5A5AAB104
      6A6AAB105
      7B1BAB106
      8B2BAB107
      9B3BAB108
      10B4BAB109
      11B5BAB110
      12B6BAB111

       

      Regards,

      Nagaraj K