Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI,
You could try this.
Average - num(avg(Rev),'##')
Min - num(min(Rev),'###')
Max - num(max(Rev),'###')
Regards,
Janzen