I have two restricted measures in SAP Analytics Cloud - Current Quarter Data, and Previous Quarter Data.
I want to be able to dynamically change these quarters based on setting a value - for instance - if i set a variable 'Current Quarter' as 2021-Q4, it should automatically set the filter of current quarter data to 2021-Q4, and previous quarter data to 2021-Q3.
I am aware that we can use lookbacks in time ranges for this, but I do NOT want the current quarter to change automatically, and instead have control on what the 'current quarter' variable is.
Is there any way to implement this - wherein changing a variable such as current quarter would modify the filters on these restricted measures.
Thanks and regards,