Vizlib Community

Submit a ticket Sign in
Welcome
Login

Pivot table - suppress individual row levels

Sometimes row levels provide no additional information and should be individually suppressable.  It would also enable more customized pivot table / report styling while keeping defined style standards.


Example 1:

Level 1

  Level 2

     Detail

     Detail

  Level 2

     Detail

Level 1

  <only one level - why repeat description from Level 1, make null, etc.  ?!?> <--- Let me hide this optionally this one instance of this level yet still display below detail

     Detail

     Detail

     Detail


Example 2

Level 1

  Level 2

     Detail

     Detail

  Level 2

     Detail

Level 1

  Level 2

     Detail

  Level 2

     Detail

Total (or a Level 0)

<Level 1> - let me optionally hide this level (and the next) yet still display detail; unusual for pure pivot table, but not uncommon to style pivotable reports (e.g. additional detail levels show another way of stratifying some subset of data above or are subtractions against totals from above where a few line item details is preferred display method)

  <Level 2>

     Detail

     Detail

     Detail

<No Total of suppressed Level 1>

Grand Total


(this is tied to support case #9344)

Login to post a comment