Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I want to show Top state name who made highest sale in current year which is till date. I mean to say the KPI card should present like [Chennai 125K]. Also it would be calculated based on count distinct sales id as there will be duplicates.
Sales ID | State Name |
10001 | Delhi |
10002 | Maharastra |
10003 | Chennai |
10004 | Delhi |
10005 | Maharastra |
10006 | Chennai |
10007 | Delhi |
10008 | Maharastra |
10009 | Chennai |
10010 | Delhi |
10011 | Maharastra |
10012 | Chennai |
10013 | Delhi |
10014 | Maharastra |
10015 | Chennai |
Please advise.
Thanks
Or if needing the sum of sales for the region to control the name:
=FirstSortedValue(StateName &' ' &Aggr(Sum(Sales), StateName), -Aggr(Sum(Sales), StateName))
You could try this as measure in KPI,
FirstSortedValue(StateName &' ' & Sales , -Sales)
Or if needing the sum of sales for the region to control the name:
=FirstSortedValue(StateName &' ' &Aggr(Sum(Sales), StateName), -Aggr(Sum(Sales), StateName))
Solved!! Thanks for your help Steven:-)