Totals in pivot table

  • Thread starter freightliner2006
  • Start date
F

freightliner2006

Hi all,

I have a sheet where I store some records in this - simplified -
format:

Article | quantity
XYZ | 4
KLM | -2
XTR | 3
XYZ | -1

There is a minus sign when it's a shipping, otherwise it's a receiving.
The pivot table adds/subtracts quantities depending on the sign,
and shows for each Article, the quantity available in stock.
Once an article quantity become 0, I would like that row to disappear
from the pivot table,
I dont need a stock list with quantities: 0.

Is there a way to do this (not copying the pivot table and removing
manually the 0 rows...)

thanks
 

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

need help with pivot tables 1
Re: Differences instead of sums in pivot table 2
Sub Totals as a calculated field in a pivot table 2
Pivot Table Totals When Using Pages 1
Pivot Table calculated field error 2
Listing only sub totals in pivot table 1
Pivot Table Primer 3
How do I create ranges/groups in excel in a pivot table? 2

Top