Display only the max value of aggregated dimension

[Anonymous]

Hello I have the table above in which I want to display onty the max of the 2 values displayed of wal mart.(whole 1st row). How can I do this?

[jwjackso]

If you are only dealing with those 2 rows, set the dimension = Organization.

First expression =If(Sum({<Tag={'Revenues'}>} Value) > Sum({<Tag={'SalesRevenueNet'}>} Value),'Revenue','SalesRevenueNet')

Second Expression  = Max(Aggr(Max(Value),Organization))

[Anonymous]

How can I use these 2 expressions together?

[sunny_talwar]

May be one of this

Max(TOTAL <Organization> Value)