100100 CURRENCY & COIN - VAULT 37,752.50
100101 CCRRENCY & COIN - TELLER #1 11,892.59
100102 CCRRENCY & COIN - TELLER #2 14,850.55
100103 CURRENCY & COIN - TELLER #3 10,247.04
100104 CURRENCY & COIN - TELLER #4 -

In the above pivot table consisting of 3 columns and 5 rows how could I
automatically hide row 5 and all the other $0 value rows in my pivot table?

Thanks!