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.
