I'm using a pivot table.
Under "Row Labels" I have
"Customer"
"Values"
"Date"
I want to filter not only the rows with zeros (I know how to do this) but also the row labels that below themselves have only rows with zeros.
EXAMPLE
I'VE ALREADY FILTERED THE ZEROS
Chevrolet
.....Bumpers
..........Date....................2,013
..........Date....................101
..........Date....................77
..........Date....................5,556
..........Date....................8,002
.....Tail Lights
.....Windshields
.....Tires
.....Gas Caps
.....Wipers
.....Tie Rods
.....Push Rods
.....Speakers
.....Keys
.....Airbags
..........Date....................888
..........Date....................9,165
..........Date....................4,444
I want to hide
.....Tail Lights
.....Windshields
.....Tires
.....Gas Caps
.....Wipers
.....Tie Rods
.....Push Rods
.....Speakers
.....Keys
Bookmarks