Say we have the  "As of Date" on the top filter bar(Workbook/Global variable?), which is DATE instead of YEAR, we pin this filter to all the canvases in the workbook, this "As of Date" works great against our first 2 canvases to pull all different counts/analysis "As of Date", except on the third canvas which we we have visualizations with visualization filter (visualizations/section filter?) for Termination/Turnover , which we pull Current years termination counts by below visualization filter , by default is working fine (CURRENT YEAR against CURRENT DATE), but when we "As of Date" on the top filter bar to past date for example 07/01/2022, we would like the this visualization filter pull Termination count/analysis against year 2022 instead of current year of 2024, we need something like if the "As of Date" on the top filter bar is not null then VALUEOF(GLOBAL_FILTER.YEAR). How can we do that?

"HCM - Workforce Core"."Time"."Year" = VALUEOF(NQ_SESSION.CURRENT_GREGORIAN_YEAR)

Thank you for quick response ... not really simply want a different year, we want the YEAR of the "As of Date" filter on the top filter bar(Workbook/Global variable?)

for example if I select AsOfDate = 01/01/2022 in Workbook filter, I want this selected data is be available in my Virilization filter of "Current Year", so that the current year is 2022 against "AsOfDate = 01/01/2022"

Thank you very much Gayathri for your help .... Now I can pass the selected value from Workbook Filter to Visualization filter through parameter. But realized only one day's data coming into workbook because of that Workbook AsOfDate Filter, then the below becomes the new issue now :-)

The below can calculate the past 12 month's termination count, but we want the termination count of the year of the AsOfDate parameter, do you have an idea how to do that? Wish we could pass dynamic formula instead of constant as "-13, 1" to this PERIODROLLING function?