Current Month vs Prev Month- on selecting one month prev. month not calculating

[#1]

Member Name	Current Month Amount	Prev. Month Amount
ABC	100	120
BSD	120	100
XYZ	500	550

Dear All,

Above is the table with Report i want to see.

i am using below mention set expression

for Current Month = =(sum({<MONTH1={'$(vMaxMonth)'}>} TRADE_VALUE))

for Prev. Month = =(sum( {<MONTH1={'$(vPrevMonth)'}>} TRADE_VALUE))

when i am not selecting any month, Year  or Month-Years deminsion is working fine . but when i am selecting any one month from the list then the prev. month amount is zero please help .

vMaxMonth = max(MONTH1)

vPrevMonth= max(MONTH1)-1

[tresesco · Accepted solution]

Try like:

Prev. Month = sum( {<Year,[Month-Years], MONTH1={'$(vPrevMonth)'}>} TRADE_VALUE)

[#3]

Thanks Tresesco.