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]

You need to use rank-function to find out maxium value. Expression is something like this:

=date(max(aggr(if(Rank(Sum(sales))=1, OrderDate),OrderDate)))

[anbu1984]

Try this expr

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

[#4]

It isn't working. You put the date, but I want the value, but even though I remove the date it doesnt work.

[#5]

It doesnt work.

[anbu1984]

Can you post sample data.

What are the dimensions used in the chart?

[Anonymous]

Are you using it inside of set analysis? Then expression is like this

YourDateField={"(=max(aggr(if(Rank(Sum(sales))=1, OrderDate),OrderDate)))"}

[dieter13]

Try this:

=FirstSortedValue(sales,-OrderDate)

[Anonymous]

Pedro,

You have to explain better and/or to upload an example.  The expression you show is returning maximum daily sales (by order date).  Is it what you need?  You say "didn't get any successful result" but you have to tell what the expectation is.
And "it doesn't work" isn't an explanation either

Thanks,
Michael

[#10]

Hi,

You can try this expressions.

$(=max(aggr(sum({<OrderDate= >} sales ))))

                       OR

$(=max(aggr(sum({<OrderDate= >} sales ),any one dimension field)))