Set Analysis - calculate data from the past

[#1]

Hello,

I want to calculate data from a moment in the past with a formula and set analysis, but it does not work like this

=Sum({<Year_Month={"=$(=MonthName(AddMonths(Year_Month,-3)))"}>}FC_KG)

Year_Month  has format 'mon YY', such as Apr 2017

Thanks for you answer

Kind regards

[sonysree88]

Sorry above calculation is for current date selections ,

Please use this :

=SUM({<Year_Month = {"$(=Date(AddMonths(Max(Year_Month),-3),'MMM YYYY'))"}>}FC_KG)

Regards,

Sunitha