10 Replies Latest reply: Oct 18, 2012 12:23 PM by John Witherspoon RSS

    Indent Mode does not display higher dimensions properly when collapsed

    Jonathan Dienst



      If you have a pivot table with multiple dimensions but only one expression, and use Indent mode, when the higher dimensions are collapsed, they are no longer displayed fully, even though the space is available. See the first pic (date has been pivoted, one expression):



      If you expand any one of the second level dimensions, then they display fully. But initially I need to display it at this level, and this is ugly.

      If I add a second expression, everything works as it should. See the second pic:



      Has anyone got suggestions on how to get the full text of the second dimension to display with only a single expression in the picot?

      I have resorted to a dummy expression (returning an empty string: = '') and hiding the vertical separator lines, but this causes a problem if exported to Excel.