| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table
How can you filter the result of a pivot table to show values greater than or
less than a defined value? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table
That feature isn't available in Excel 2003 and earlier versions. You can
use the Top 10 AutoShow feature to limit the number of items that are displayed. Right-click on the button for the field you want to limit Choose Field Settings Click the Advanced button Under Top 10 AutoShow, click On, and adjust the Show and field settings. DC wrote: How can you filter the result of a pivot table to show values greater than or less than a defined value? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table
Thanks for your response Debra
I'm familiar with autoshow but wasn't aware the feature I want is only available in newer versions than 2003. "Debra Dalgleish" wrote: That feature isn't available in Excel 2003 and earlier versions. You can use the Top 10 AutoShow feature to limit the number of items that are displayed. Right-click on the button for the field you want to limit Choose Field Settings Click the Advanced button Under Top 10 AutoShow, click On, and adjust the Show and field settings. DC wrote: How can you filter the result of a pivot table to show values greater than or less than a defined value? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table
Pivot tables in Excel 2007 have more filtering options.
http://blogs.msdn.com/excel/archive/...20/506172.aspx DC wrote: Thanks for your response Debra I'm familiar with autoshow but wasn't aware the feature I want is only available in newer versions than 2003. "Debra Dalgleish" wrote: That feature isn't available in Excel 2003 and earlier versions. You can use the Top 10 AutoShow feature to limit the number of items that are displayed. Right-click on the button for the field you want to limit Choose Field Settings Click the Advanced button Under Top 10 AutoShow, click On, and adjust the Show and field settings. DC wrote: How can you filter the result of a pivot table to show values greater than or less than a defined value? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| Display the source for a pivot table page field | Excel Worksheet Functions | |||
| Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
Linear Mode
