Aggregated funcionts

[Joaquin_Lazaro]

Hello:

I've two text boxes with these expressions

= max(aggr(sum(Sales), YearMonth))

= min(aggr(sum(Sales), YearMonth))

The best and the worse sales grouped by YearMonth, over the current selections.

Now I need to create to new text boxes with the best and the worse sales grouped by YearMonth, but over the complete data model.

What's the correct expression to get what I need?

Thanks for your help.

Joaquín

[#2]

dont know if it works but try

sum(max(aggr(sum(Sales),YearMonth)))

[MK_QSL]

= max(aggr(sum({1}Sales), YearMonth))

= min(aggr(sum({1}Sales), YearMonth))

Or

= max(aggr(sum(TOTAL Sales), YearMonth))

= min(aggr(sum(TOTAL Sales), YearMonth))

[Joaquin_Lazaro]

Not. I want the best ignoring the current selections

[swuehl · Accepted solution]

= max({1} aggr(sum({1} Sales), YearMonth))

= min({1} aggr(sum({1} Sales), YearMonth))

and please try to avoid duplication of threads.

[MK_QSL]

Same as swuehl suggested...

= max({1}aggr(sum({1}Sales), YearMonth))

= min({1}aggr(sum({1}Sales), YearMonth))

[sunilkumarqv]

Try this

=Max(aggr(sum( {1} Total Sales ),YearMonth))

=Min(aggr(sum( {1} Total Sales ),YearMonth))

[Joaquin_Lazaro]

The max works good.

The min shows 0 and I don't have cero value on any YearMonth.

I had a problem on the navigator, that's the reason of the duplication therad.

[Joaquin_Lazaro]

The answer proposed by swuehl works.

= max({1} aggr(sum({1} Sales), YearMonth))

= min({1} aggr(sum({1} Sales), YearMonth))

There was an incorrect value on one record, that generates a wrong value.

Thank you very much.

Joaquín