| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot tables show zeros | Excel Discussion (Misc queries) | |||
| pivot tables using same heading to show multiple data information | Charts and Charting in Excel | |||
| my pivot tables are correct but my totals and GT don't show | Excel Discussion (Misc queries) | |||
| pivot tables-drop data in, how to make it show as columns instead | Excel Discussion (Misc queries) | |||
| show items with no data option in pivot tables | Excel Discussion (Misc queries) | |||
Linear Mode
