Forum Discussion

Kit_Tyrrell's avatar
Kit_Tyrrell
New Contributor II
2 years ago

Row with Column Over-ride of Year/Period

Hi All, I am trying to create a simple CV with one column set to T#POV.Prior12, T#POV (to get 13 rolling periods).   For Rows I have 3.  CurrentYear, Budget, and PriorYear.   On PriorYear row I am t...
Cube View
NicoleBruno's avatar
NicoleBruno
Valued Contributor
2 years ago

Hello!

 

The member filter on the column override is off. The T#PovPrior1 is a standalone variable and doesn't get any expansions after it. Seems like you might want something like this there instead of what you have: 

T#PovPrior13, T#PovPrior14, T#PovPrior15, T#PovPrior16, T#PovPrior17...

  • NicoleBruno's avatar
    NicoleBruno
    Valued Contributor
    2 years ago

    I forgot to add - I use a QV to confirm my member filters are working the way I'm expecting which might be useful for you too.