Forum Discussion
Solved
Pivot Table Formatting Help - Remove Blank tertiary rows without removing Primary/Secondary rows
Hello, I have a data table that contains 3 columns that I am using as the rows in my Pivot Table. I have "Brand", "Style" and "SubStyle". In SubStyle, only some rows have a value, as only certain...
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.
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!
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!