Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I have a requirement to show Minimum and maximum value in KPI.
For example :
Dimension is Client Type (A,B, C, D, E)
Measure - sum(Volumes)
Client Type sum(Volumes)
A 20
B 60
C 10
D 80
E 120
So the KPI should show Client Type Max - E(120) and Min - C (10). Is it possible?
Appreciate your time and support in advance.
Regards,
Richard
Hi Anat,
Thanks for your response.
I did use the below expression to derive Max but not sure what is it to derive minimum value
FirstSortedValue(ClientType, -Aggr(Sum(Volumes), ClientType))
Regards,
Richard
for min value
FirstSortedValue(ClientType, Aggr(Sum(Volumes), ClientType))
But its not working, I'm having more than 1 values which is having minimum values, in this case, how can we acheieve.