Display a KPI that shows both the Highest Value and Who Achieved it.
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?