Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot table with dimension in rows and colums

Hello,

I need a pivot table with dimensions in rows and columns, something as this:

pivot_table.PNG

¿Is this possible?

Thanks

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can't have two dimensions as rows in one column. You can have two dimensions arranged horizontally. Drag the header of the dimension to the right to above the expressions. When you see a think blue line let go and the dimension will be pivotted to horizontal layout. Repeat the for each dimension that you want shown as columns.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

You can't have two dimensions as rows in one column. You can have two dimensions arranged horizontally. Drag the header of the dimension to the right to above the expressions. When you see a think blue line let go and the dimension will be pivotted to horizontal layout. Repeat the for each dimension that you want shown as columns.


talk is cheap, supply exceeds demand