Ignore selected filters and keep the one from Set Analisys

[RodrigoAsa]

Dear all, good morning.

I have a problem: I need it to maintain the date filter I set in the analisys set. In this case, it would be the last three months (in this case, August, September, and October, since it's October), but it's only showing the current month. So, I'd like to know possible solutions to this problem.

Thank you all in advance.

[robert_mika · Accepted solution]

Maybe lie that?

Sum({$<  Product=,Customer=,Year={2009}>} Sales)

The part in your post is different?

What is the issue

[RodrigoAsa]

In this part of my analysis set: [Data de Emissão] = {">=$(vMêsAtual2Retro)<=$(vFimMêsAtual)"},
The variable 'vMêsAtual2Retro' is used to get the two retroactive months and 'vFimMêsAtual' shows the current month. The objective is to get the revenue for the current month and the two retroactive ones.

[Vegar · Accepted solution]

I assume you are making selections to other date/month fields than  [Data de Emissão] . As @robert_mika  suggests, you might need to clear those selections. Let's assume you select October in a [Month] fields. Then try this:

SUM({<Month, [Data de Emissão] = {">=$(vMêsAtual2Retro)<=$(vFimMêsAtual)"} >} [Amount])