Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a set of data like below:-
Sales office |
Uttar Pradesh SO |
Gujarat SO |
Delhi Haryana SO |
Delhi Haryana SO |
Punjab Himachal SO |
Kerala SO |
Kerala SO |
Punjab Himachal SO |
Punjab Himachal SO |
TAPSO |
Uttar Pradesh SO |
Uttar Pradesh SO II |
Uttar Pradesh SO II |
Uttar Pradesh SO II |
I have to display the name of, max of this sales office in a KPI, where most cases were registered,How to write expression for this?
In this example suppose, Uttar Pradesh SO II has max of 4 cases, so it should display 'Uttar Pradesh SO II'.
Please suggest.
Try this:
FirstSortedValue([Sales Office],-AGGR(
count([Sales Office])
,[Sales Office]))
Try this:
FirstSortedValue([Sales Office],-AGGR(
count([Sales Office])
,[Sales Office]))
Your dataset example seems to be missing one record for Uttar Pradesh SO II.
Add in a record for Uttar Pradesh SO II into the inline table and you should get the result.
Hi Arthur,
Thank you very much, it's working as expected.
Regards