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

[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))

[swuehl · Accepted solution]

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

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