set analysis

[Anonymous]

I need to show the income of last month.

I have:

=num(sum({<Month_Num={$(vMonthCal)},Year={2017}>} [TRUEPRICE]),'#,##0 ')

once vMonthCal==num(Month(today()))-1

and yet when i pick another quarter, the numbers change and not remain the numbers of the previous month.

How do I fix it..?

[vishsaggi]

May be this? Quarter is like your Quarter field name. If your name is different replace with your actual Quarterfieldname.

=num(sum({<Month_Num={$(vMonthCal)},Year={2017}, Quarter=>} [TRUEPRICE]),'#,##0 ')