ExcelBanter - Pivot Table SubTotals

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table SubTotals (https://www.excelbanter.com/excel-discussion-misc-queries/166651-pivot-table-subtotals.html)

Corby

Pivot Table SubTotals

In excel 2003 I have a pivot table that I have filtered out to get the
information that I need to see. However when I use the sum function for a
column (company Name) the subtotals still show some of the company names that
I have filtered out. Does anyone know how to get rid of the names without a
value?

THX..

All times are GMT +1. The time now is 06:22 AM.