Forum Discussion
Pivot Table Formatting Help - Remove Blank tertiary rows without removing Primary/Secondary rows
Ahhh , wait!
Before you do that, have you tried just clicking on each of the little boxes with the "-" in them, next to the styles that have no sub-styles? Doing that eliminates the "blank" rows from the display in a Pivot Table, yet it still is accurate.
I don't know if the ratio of those with and those without sub-styles in your full product line is the same as that shown in your example. But if it is -- if there are really very few sub styles -- I would suggest you just re-categorize these two as Styles.
(Now, admittedly, I don't know whether that would create complications in some other aspect of the business, but you asked whether there was any "work around" and this re-categorizing strikes me as the epitome of work around.)
- There are about 11% of Styles that contain a SubStyle. I would love to omit the SubStyle Column all together, but alas, I am the order taker in this situation. After searching high and low, it does look I can only show all or none of a row label. Not split between some showing and some not showing.
I think instead of trying to find a way to omit these blanks in SubStyle while preserving the Style category labels. I am going to fill all Blanks in the SubStyle with the same value that is in Style. For readability of the business.
Thank you so much for your help and quick reply mathetes!Ahhh , wait!
Before you do that, have you tried just clicking on each of the little boxes with the "-" in them, next to the styles that have no sub-styles? Doing that eliminates the "blank" rows from the display in a Pivot Table, yet it still is accurate.
- Thank you so much! I hadn't even thought of that solution.
Have a wonderful week!
