Set Analysis on Aggr()

[Aditya_Chitale]

Hi All,

I want to show previous 12 months variance in a line chart based on max month selected by user (if month= May 2020, line chart should show data from May 2019 to May 2020). The variance I want to show in line chart is based on region level. So I have aggregated it on region ).

Expression I used:

Sum(Aggr((Sum({<PPV_Date={">=$(=Date(addmonths(max(PPV_Date),-12),'DD-MM-YYYY'))<=$(=Date(max(PPV_Date),'DD-MM-YYYY'))"},[PPV Fiscal Month]=>}([PPV Variance due to currency YTD])*[Exchange Rate])) ,[PPV Purchase Region]))

even after using this expression, it is showing variance only for the selected month.

Kindly suggest a solution for the problem.

Regards,

Aditya

[JustinDallas]

Is there a way we can get some dummy data to work with?  It also helps to have a small table of what results you are expecting to get.