Prior year in row with dynamic columns
Hello I am trying to create the below CV. I am struggling with the Account % Change from PY.
Is there a way to reference the column time - 1 year and still have it dynamic?
2022m1 ...
Forum Discussion
Do you have the Prior Period (Prior Year) as a Column in your Cube View? if the data is present in the Column you could do CVC math. Send a screen shot of your editor and I could help with the specific syntax in your use case.
Something similar to this: These are Columns in a particular Cube View and how the CVC dynamic math syntax would look:
S#Actual:GetDataCell(CVC(Actual_YTD) - CVC(CompScen_YTD)):Name(Var $)