Hi, Thanks for the response , hope you have gone through the problem statement. Issue is with the AGO function where for Jan-26 , Dec-25 data is nor reflecting. Function used AGO(Revenue, Fiscal period,1) Regards

in Subject Area we have ,but in dashboard filter we have only year and month ..and based on the user selection of month ,we have to show previous 12 month data .

I need 12 month data to be shown for the selected period , for example If user selects - Nov-25 ..data in the the bar graph should show from Nov-25 to Dec-24.

Hi Silvio, Thanks for the quick reply, but this was working fine earlier. But after data refresh we reset the warehouse , and now this issue is occurring though few of the DFFs are working fine. Regards Dharmendra

Hi Anitha, Thanks for the response. I understood that using any columns from any SA will work if we have the data granularity at same level. Now in my case, I have to create 4 analysis in one canvas which will required three SA like AR, Inventory and SCM-COGS(for Gross Profit). In this case, how my dashboard filter will…