Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a requirement where I have to display the Max of Sum of Amount spent in a straight table.
In the above case both A and C have 1000 and 1000 is the max.
Have given Name as dimension.
Can anyone help me on Expression please.
Expression can be this:
If(Sum(Amount) = Max(TOTAL Aggr(Sum(Amount), Name)), Sum(Amount))
Expression can be this:
If(Sum(Amount) = Max(TOTAL Aggr(Sum(Amount), Name)), Sum(Amount))
Hi Koushik,
Below two expressions should work fine:
Max(aggr(Sum(Amount),Name))
or
FirstSortedValue( Name , -Amount )
Thanks,
SV
Thanks a lot Sunny.
No problem
I am glad I was able to help.
Best,
Sunny