Hide zero totals in pivot table report

G

Guest

I have a file that I am importing that has warehouses across the top and the
inventory items down the side. Not every warehouse has every item. When I
try to do a pivot table on the warehouse (part number in row area) I get
EVERY inventory item, even those with zero values. Is there any way,
excluding macros, to have the rows where the total inventory for that part
number is zero not display? Thanks for any help.
 
S

steven1001

This should work..
assume Col A is product, Col B is qty, Col C is labelled "display?" an
rows 2 to 5 contain data
C2 contains a value calculated by the formula..
=IF(SUMIF($A$2:$A$5,A3,$B$2:$B$5)=0,"hide","show")
copy formula into c3 to c5.

In the pivot table put the "display" column in page and select onl
"show". If you are using 'get external data' the formula can b
auto-added by the refresh.

regards..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exclude zero values from pivot table 0
HELP!!! 1
Pivot Table not cooperating 4
Pivot Table totals 3
pivot table data 2
Hide zero values in a pivot table 3
Need help to Simplify a Complex Calculation on a Form 0
Surpressing rows and columns with zero values in a pivot table 1

Top