How to disregarding any selection on expression?

[#1]

Hello,

how do I not consider selections month and year in the formula below, using Set Analysis? Thank you.

=num(if( Aggr(Rank(Sum(Value)),Year,Month) <= 3, sum(Value)) / 100,'#.##0M')

[jaimeaguilar]

Hi,

it is possible to disregard selections made by user with this syntax:

=num(if(Aggr(Sum(Value)), Year, Month) <= 3, sum({$<Month=, Year=>} Value)) / 100, '#,##0M')

Month= and Year = inside Set analysis will cause that selections on those fields will be ignored.

As a note, it is possible that this set analysis also has to be included in the if statement.

Regards

[#3]

I tried this before, and still consider the Month dimension selection....

[jaimeaguilar]

Have you tried putting set analysis also in the if Statement?

=num(if(Aggr(Sum({$<Month=, Year=>} Value)), Year, Month) <= 3, sum({$<Month=, Year=>} Value)) / 100, '#,##0M')