Pivot tables - how to show only show data > or < $10k

P

pattyb

I would like to show only that data that is >$10k or < $10k. I don't care
about the smaller dollar amounts. How do I do this?
 
P

pattyb

Smartin - adding the field as you suggested solved my problem. I'm still
curious if there is a way to do this w/in the pivot table paremeters. Thanks
for your help.
 

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

Big problem................. 9
combining pivot tables, then making a ranges. 1
Use commas as decimal separator 2
replace ' in cells 4
Sumproduct - I think - Counting occurances that fall into criteria 1
Random Number Selection 4
Pivot Tables - delete rows from Master List 2
Removing leading 0s 2

Top