Pivot Label Filter in Excel 2007

H

Hennie

Hi,

I have a speadsheet of invoices which consists of Date, Invoice,
Invoice-Code and amount. I use a pivot to list the total invoiced per
Invoice-Code, but need to exclude codes that contain words like "Bond" and
"DC".
The filter works fine if I select one word only.
Can I and if so, how do I add more that one word to the filter?

Thanks
Hennie
 

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 suggestions on layout to report/pivot 5
Using 'The count of' column in a pivot table formula 0
Creating a Custom Data Entry Form to Update Multiple Excel Records atOnce 0
Pivot table setup 2
From Scratch - Tracking Payables 1
Pivot table formatting - colors 3
Pivot 2007. Format row field 0
Cumulatively list data from each new worksheet 1

Top