Forum Discussion
Hi Kit - I'm a bit confused with what you're specifically asking for, but you need the pipes symbol to accomplish it, if you are using the substitution variable of CVYear.
T#|CVYear|.Months would be the correct syntax to get all months in the Cube View Year. To get the prior year's months, try T#PeriodPrior1(|CVYear|).Months.
I'm not sure what this cube view is being used for, but I typically like to allow the time period to be selectable for the end user (unless it's forms related where I typically use T#WF). If you want to make it more dynamic, throw in a parameter, such as |!ParamMonth!| in place of |CVYear|
Thank you very much for the reply. I'm trying to get to a CV that would display 2 columns of data, Current Year and Prior Year for each of the 12 periods of a year.
On rows, I am just displaying the CY and Months.
I thought I could then override the row for prior year with something like this:
I've not been able to get that to display though. I have seen in most examples folks are doing similar things by displaying the periods in columns vs row, but I have users use to seeing the periods in rows, so was trying to replicate that. Any thoughts are greatly appreciated.