Community
Hi,
I want to show the date with has the highest total sum of amount in a KPI , does anyone know how.
Amount Date
Thanks
May be this
FirstSortedValue(Date, -Aggr(Sum(Amount), Date))
View solution in original post
create a sheet with Date in dimension,
and in expression :
if(sum(kpi) = max(total aggr(nodistinct sum(kpi),date)),date)
date with the max sum kpi will appear
regards
Thanks, have previously seen your answer elsewhere and tried it.
Realized that my output was not in date format.
Total carelessness on my side.
Yes!!!!
I made a copy paste of your text
Replace And with, (comma)
And Maxstring in place of max for a string
I am using a similar formula. It works fine without '-'(minus) sign, but when I'm using a minus sign, I am not getting any value.
I used the same formula for Table and it works, but I'm not getting any values for a KPI.
