Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display additional dimension in pivot (indent mode)

I have a problem with the visualization of my pivot table.

For a complex table I need 4 dimension and more then one key figures. As I created the table with one or more key figures in the normal mode, it's works fine and all dimensions could be displayed (see the attachement). The problem is now, that the column width is the same for all columns what we do not expected. For that, I found the Indent mode (in the register Style). However, after I changed the pivot to the indent mode, the values of the dimension "Dim1" are hidden (see attachement).

Do anywho have an idea, how could I display the Dim1 or other any input.

many Thanks

3 Replies
marcus_sommer

The column width is always equal for an single expression, also with intend-mode. Perhaps another approach in the pivot structure fit better for your needs - see the attachment.

- Marcus

Not applicable
Author

Many thanks. Could I hide the total column and rows in this pivot table?

Thanks

marcus_sommer

Yes you could for each dim enable/disable these part sum - in tab presentation top left.

- Marcus