dbeavon
4 years agoContributor
Excel Add-in : Dimension Levels to be displayed in Columns
I'm having trouble figuring out how to organize the layout of my cubeview.
I'd like a tabular layout where dimension levels will occupy their own columns. Below is an example where I am retrieving data from my cube by week. But I want to display the parent month and quarter in their own columns, next to the weeks.
I am able to build the layout shown in the first image above. This is accomplished using TreeDescendants for the year. But I can't find a way to organize my quickview in a tabular layout (see the second image).
Any help would be much appreciated! Sorry for the basic question. (I haven't yet found a good source of training material for Excel quickviews.)