The first $ in your expression is telling it to include all selections. So you're explicitly telling it to include the Month and Day selections when doing the sum. Instead, you need to tell it to IGNORE the month and day selections (as well as any other fields that are in your calendar). Something like this:
Another thing you need to make sure of is that the Year field and the LAST_WORKDAY_REPDATE_VAR are formatted the same, as set analysis appears to do a text rather than numeric comparison.
The first $ in your expression is telling it to include all selections. So you're explicitly telling it to include the Month and Day selections when doing the sum. Instead, you need to tell it to IGNORE the month and day selections (as well as any other fields that are in your calendar). Something like this:
Another thing you need to make sure of is that the Year field and the LAST_WORKDAY_REPDATE_VAR are formatted the same, as set analysis appears to do a text rather than numeric comparison.
Can you help me in another question related to this? I have a calendar and I have mapped, as you say, and it is working almost perfectly: sum({} Sales) The only problem is this: If the use selectes the Date: 05-08-2009, I want to show the YTD value until that date, and not until today. I've changed the expresion to this: sum({} Quantidade) But I can't get the desired results. Thanks for all your help
