tora111
asked on
Pivot table - grand total filter
Below is a pivot table, is it possible to set filter on "Grand Total" such as no hide when "Grand Total" is 0?
ID A B C D E F G H Grand Total
22298175001 0 0 0 0 0 0 0 0 0
22298175002 0 0 0 0 0 0 0 0 0
22298175003 0 0 0 0 0 0 0 0 0
22298175004 0 0 2 1 1 3 0 1 8
22298175005 0 0 2 0 1 1 1 0 5
ID A B C D E F G H Grand Total
22298175001 0 0 0 0 0 0 0 0 0
22298175002 0 0 0 0 0 0 0 0 0
22298175003 0 0 0 0 0 0 0 0 0
22298175004 0 0 2 1 1 3 0 1 8
22298175005 0 0 2 0 1 1 1 0 5
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Book3--1-.xlsx