Excel Add-in : Dimension Levels to be displayed in Columns

dbeavon
Contributor

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.

 

dbeavon_0-1644187722787.png

 

 

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.)

 

0 REPLIES 0