Set Analysis to ignore filter

[JuMo]

In one chart, i am using a set analysis to ignore the selection on the month filter

Sum({<[Calendar.Month]=>} Fact.Actual)

And it works correctly, it making the sum for all the month ignoring the month selected

However, when I introduce another factor to the set analysis, the sum is calculated only for the selected month

Sum({<[Calendar.Month]=>*<Product = {"Product 1"}>} Fact.Actual)

Shall I use another operator ?

[seanbruton]

Hi JuMo,

Please try this and see if it works for you.

Sum({<[Calendar.Month]=-,Product = {"Product 1"}>} Fact.Actual)

or

Sum({<[Calendar.Month]=,Product = {"Product 1"}>} Fact.Actual)

Regards

Sean

[JuMo · Accepted solution]

Thanks you Sean, its not working

However I've tried with an outer set expression and it works ...

{<[Calendar.Month]=>} Sum({<Product = {"Product 1"}>} Fact.Actual)

... I don't know why