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

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?

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

pattyb wrote:
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?

One way would be to add a field to the source data, call it "10K Flag"
with a formula like =A110000. Then include this field in the pivot
table, say as a Page area filter.

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

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.

"pattyb" wrote:

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?