Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table: filter values great then, lower then...
So far I can only fitler TOP X pr BOTTOM X items of the pivot table, but I
would need to filter items i.e. greater then certain amount. Can this be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table: filter values great then, lower then...
Nope Top X or Bottom X. To do what you want you will need to add a helper
column to tyour source data which serves to flag the items you want... -- HTH... Jim Thomlinson "Tomas" wrote: So far I can only fitler TOP X pr BOTTOM X items of the pivot table, but I would need to filter items i.e. greater then certain amount. Can this be done? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table: filter values great then, lower then...
Thanks.
"Jim Thomlinson" wrote: Nope Top X or Bottom X. To do what you want you will need to add a helper column to tyour source data which serves to flag the items you want... -- HTH... Jim Thomlinson "Tomas" wrote: So far I can only fitler TOP X pr BOTTOM X items of the pivot table, but I would need to filter items i.e. greater then certain amount. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table hanging on to deleted values | Excel Discussion (Misc queries) | |||
Selecting a range of values on pivot table attribute with a macro | Excel Discussion (Misc queries) | |||
Pivot Table Size | Charts and Charting in Excel | |||
auto filter data within pivot table | Excel Discussion (Misc queries) | |||
How do I filter "Blank" cells in Pivot Table | Excel Discussion (Misc queries) |