Set analysis - Not returning desired result

[adurgani]

This is my formula:

Sum({$<Dimension={'Actual'},[Month]={'January','February'}>}[Line Amount]) + Sum({$<Dimension={'April Forecast'},[Month]={'March','April','May','June','July','August','September','October','November','December'}>}[Line Amount])

When I use the month listbox and filter to January I still get the full amount and it doesn't show me just January. How shall I amend the formula to get the desired result?

[adurgani]

If we drop the CrossTab table, doesn't the data disappear?

[vishsaggi]

No I am loading that cross table data into Final table which you can see below the NoConcatenate keyword. So Final table holds the data and Actual table will get concatenated to this Final table.

[swuehl · Accepted solution]

Try using the intersection operator *= :

Sum({$<Dimension={'Actual'},[Month] *= {'January','February'}>}[Line Amount]) + Sum({$<Dimension={'April Forecast'},[Month] *= {'March','April','May','June','July','August','September','October','November','December'}>}[Line Amount])

or whatever is appropriate for your requirements.

[adurgani]

This is perfect and it worked!!! Thanks much Stefan for the answer and Vishwarath for bringing me along to ask the right questions!! !