Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value Filter in a Pivot Table.
I am trying to apply a value filter in a pivot table, but the options are
greyed out. Why could this be. The scenerio, I have a huge file, with client data. I want to see this data broken down 1st by Sales Manager, 2nd by client. I can get this far. Now I would only like to see data for "Total" sales over 100K. The value filter is not available. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value Filter in a Pivot Table.
Deb wrote:
I am trying to apply a value filter in a pivot table, but the options are greyed out. Why could this be. The scenerio, I have a huge file, with client data. I want to see this data broken down 1st by Sales Manager, 2nd by client. I can get this far. Now I would only like to see data for "Total" sales over 100K. The value filter is not available. Of all the crazy coincidences... I was scratching my head over this last night, convinced there must be a way to filter aggregate PT values, and became convinced there is no way. Then, merely hours later, Jon Peltier posted this on his blog: http://peltiertech.com/WordPress/autofilter-tricks/ Works exactly as you asked. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Pivot Table - Filter | Excel Discussion (Misc queries) | |||
filter & pivot table | Excel Discussion (Misc queries) |