Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have three fields. First is a field that contain date, second is a field that contain names of the town and third contain the sum of sales.
Now I want to create a KPI with the field of the town and I want show the town with maximum sales. The maximum sales per town changes with date then the town with maximun sales changes with the date. I want that when I change date this KPI change name of the town. Thank you
May be this
FirstSortedValue(Town, -Aggr(Sum(Sales), Town))
Thank you very much