Forum Discussion
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 Styles have SubStyles. This results in my Pivot Table having a "(blank)" row label for all Styles that do not have a SubStyle. On each row that does not have a SubStyle, I would like to omit the "(blank)" rows while still preserving the Brand and Style row labels. However, when I filter out "(blank)" from the SubStyle row label, every Style that does not have a SubStyle is filtered out.
Is there any work around where I can only have the two Row Labels on items without the SubStyle value, and have all three Row Labels on items with a SubStyle Value
Example of no Filter on "SubStyle"
Example with "(blank)" filtered on SubStyle
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.
4 Replies
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.
