Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Many thanks. Could I hide the total column and rows in this pivot table?
Thanks
Yes you could for each dim enable/disable these part sum - in tab presentation top left.
- Marcus