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)