Cube View splitting quarters in columns
Hello,
I have this Cube View that I created in which I have to move the half year (H1) column to be in between Q2 and Q3 in order to match the formatting of the report that I was given as the m...
Since it seems you are using the WFYear, I would suggest using the substitution variable for that instead.
The column definition would be the following to move H1 between Q2 and Q3:
T#|WFYear|H1.Children, T#|WFYear|H1, T#|WFYear|H2.Children, T#|WFYear|H2Use the same concept for selecting a quarter of your choosing:
T#|WFYear|Q3This will give you Q3 of the workflow year.
These are quick ways of doing this, but this could be accomplished in many other ways.
Try this.
To select a single quarter, create a parameter and use that in your member filter.
