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?
 
S

smartin

pattyb said:
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?
Click to expand...

One way would be to add a field to the source data, call it "10K Flag"
with a formula like =A1>10000. Then include this field in the pivot
table, say as a Page area filter.
 
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

Sumproduct - I think - Counting occurances that fall into criteria 1
combining pivot tables, then making a ranges. 1
Joining 10K rows to 10K rows 10
Pivot Tables - delete rows from Master List 2
Compute Tax? 0
Apply Filter to source of Pivot Table 2
Cumulative sum, based on previous data 0
Dealing with a Pivot Table (when I don't want to) 0

Top