PY dynamic
I am writing the Business rule in Revenue % account dimension, Revenue % = X / PY Y. My PY can be based on POV. For example, if user can select current year as FY2024 then PY is FY2023 or If user choose MAY 2024, then PY is MAY 2023 or if user choose Q2 2024 then the PY is Q2 2023.
I am using this code and I am able to achieve if it is year, but I need more of dynamic based on user selected PoV. how to automate this code based on PoV. any suggestions would be really appreciated.
Return api.Data.GetDataCell("-A#X / (A#Y:T#GlobalPrior1")
