Max value in Straight table

[Anonymous]

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.

[sunny_talwar · Accepted solution]

Expression can be this:

If(Sum(Amount) = Max(TOTAL Aggr(Sum(Amount), Name)), Sum(Amount))

[#3]

Hi Koushik,

Below two expressions should work fine:

Max(aggr(Sum(Amount),Name))

or

FirstSortedValue(  Name , -Amount )

Thanks,

SV

[Anonymous]

Thanks a lot Sunny.

[sunny_talwar]

No problem

I am glad I was able to help.

Best,

Sunny