Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe lie that?
Sum({$< Product=,Customer=,Year={2009}>} Sales)
The part in your post is different?
What is the issue
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.
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])