set analysis

Anonymous — Mon, 18 Sep 2017 06:41:18 GMT

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..?

Re: set analysis

vishsaggi — Mon, 18 Sep 2017 17:13:25 GMT

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 ')