Calculate the maximum value

[#1]

Hi everyone,

I have a dimension and I want to calculate the maxium value from my data. In the example I saw it says it should be calculated by the following expression:

$(=max(aggr(sum(sales), OrderDate)))

I already tried but I didnt get any successful result. Can someone help me out?

How can I calculate the maximum in the expression where the data has different dimension but I want to calculate the maximum value from all my data. I read it can be calculated using the expression $(=)

Any thoughts?

[Anonymous]

BTW, if you have multiple months, each month will have its own row, and you need max value per row, not global - remove month from the aggr.  It will be:

if(secondarydimensionality()=1, sum(Numbers), max(aggr(sum(Numbers), Weekday)))