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