Pivot table
 

How can you filter the result of a pivot table to show values greater than or
less than a defined value?

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

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

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