Set Analysis with Sum Function

[Anonymous]

Hi,

I am trying to show sum of 2 fields for current selected month and the previous month, but for some reason I am not able to do so.

This is my data and I want when user selects a month It will show the sum of Sale1+Sale2 along with the previous month in one row.

I managed to get the value of previous month using a variable, but when I use the formula its showing in two rows.

This is my formula. I am using a straight table.

Please help.

[sunny_talwar]

Try this:

Above(Sum({<Month = {'$(vLast)'}>} Sale1))