Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
For Highest Spend
Max(Aggr(Sum(Spend), Group))
For Group with highest Spend
FirstSortedValue(Group, -Aggr(Sum(Spend), Group))
Great Stuff Sunny that's working
Thanks!