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
Hi!
I have a similar problem but with Rows, I am trying to do the following but the time filter doesn't work:
GetDataCell(Variance(CVR(Row8),CVR(Row8):T#PovPrior1)):Name(Incremental RWA EOP)
Row 8 is also a CVR calculated row. I have Quarters in columns, so need to do the formula as dynamic as possible.