3 Replies Latest reply on Jul 20, 2016 11:37 AM by Simon Runc

    Parameter controlled hierarchy...don't want headers/columns to display at higher levels

    John Conlon

      Hi,

       

      I've created a parameter and calculated fields to control the hierarchy in a table.  It works as I would like, but when I'm at any level except the lowest there is a lot of white space in the table (since the columns are always displayed for all levels even though the elements for each are not).  In the picture below I've chosen the highest level (Level 1), but still see the blank space for Level 2 and Level 3.  I've also attached a sample workbook.  Is anyone aware of a workaround that would get rid of this extra space when not in use?

       

      Thanks,

      John