Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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))
How can I use these 2 expressions together?
May be one of this
Max(TOTAL <Organization> Value)