Display a KPI that shows both the Highest Value and Who Achieved it.

[sweens78]

Hi Guys,

this is probably simple but I'm trying to display a visual KPI on my dashboard (in a box maybe) that shows just the group that has highest spend and what the spend was.  I don't want a big long table showing all the values just one value if that makes since .

So for example say if CHO 1 was the highest group and they spend 90000... I want it to look like the below.  I have the table that shows all the values so is it a text box with a formula of some kind?

Highest CHO Group and Value

CHO 1

€90000

[sunny_talwar]

For Highest Spend

Max(Aggr(Sum(Spend), Group))

For Group with highest Spend

FirstSortedValue(Group, -Aggr(Sum(Spend), Group))

[sweens78]

Great Stuff Sunny that's working

Thanks!