1 Reply Latest reply: Oct 8, 2012 9:14 PM by Janzen Jino Balasbas RSS

    Min, Max Value

      Hello All,

      I have  a requirement where i need to shaow Min/Max/Avg values

       

      Client    Rev

      1          100

      2            50

      3            75

      4            25

      5           -50

      6           -25

       

       

      The O/P should be

      Max: 100

      Min:   -50

      Avg:    29  (For Avg the client can vary)

       

      i was able to achieve max using the below as dimension and then hiding the dimension in the presentation.

       

      =

      aggr(rank(sum(Net)),Client

      )

       

      is there ay other way that i can use .

      Thanks