Set Analysis without selection

[#1]

Hi all,

I have a problem with my app.

I have one dimension :

- Country

And 3 expression :

- Turnover N : TO

- Turnover N-1 : TON

- Common Turnover N-1

In the "Common Turnover N-1", I want to have the Turnover N-1 Only for products wich have Turnover in N and N-1.

So I use this expression :

sum ( aggr( if ( sum(TO) > 0 AND sum({<YEAR={$(vMaxYearN1)}>}TO) > 0 , sum({<YEAR={$(vMaxYearN1)}>}TO) , 0 ) , Product))

When I have all dimension, the result is good.

But when I clik on one country, the result change.....because the expression work on common article for just this country.

But I want the expression work on all product, with or without selection, To have the same result...

I'm not sure I explain correctly, sorry for my english...

Thanks in advance

Nicolas

[#2]

Yes I'm ok, I made that :

Change the dimension to Article.

Change the expression to If (sum(CA) > 0 , 1 , 0)

And Change the Total to "Sum of Rows"

The Total il 1963. It's the good Total.

But with the other Expression, and the group, the Total is 8697....

[swuehl]

Why do you want the GRP dimension field in the advanced aggregation when you are not using it in your chart?

With only Article as dimension, you can remove the GRP dimension field:

=sum( aggr( if (sum( CA) > 0 , 1 , 0),Code_Article))

Maybe I am just missing what you are trying to do.

[#4]

No I want to see result by GRP but calculation need to be effective at the article level.

So to verify, we can test with other expression and Article in dimension.

And normaly, we should have the same result between the two expression.

1963.

Do you understand what I mean ?