Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
= max({1} aggr(sum({1} Sales), YearMonth))
= min({1} aggr(sum({1} Sales), YearMonth))
and please try to avoid duplication of threads.
dont know if it works but try
sum(max(aggr(sum(Sales),YearMonth)))
= 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))
Not. I want the best ignoring the current selections
= max({1} aggr(sum({1} Sales), YearMonth))
= min({1} aggr(sum({1} Sales), YearMonth))
and please try to avoid duplication of threads.
Same as swuehl suggested...
= max({1}aggr(sum({1}Sales), YearMonth))
= min({1}aggr(sum({1}Sales), YearMonth))
Try this
=Max(aggr(sum( {1} Total Sales ),YearMonth))
=Min(aggr(sum( {1} Total Sales ),YearMonth))
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.
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