ExcelBanter - how do I get a top 25 on a pivot table in excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I get a top 25 on a pivot table in excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/236128-how-do-i-get-top-25-pivot-table-excel-2007-a.html)

Peter

how do I get a top 25 on a pivot table in excel 2007

In a pivot table in excel 2003 I have no problem generating a "top 25" in a
pivot table. But I'm having a problem in excel 2007 restricting my pivot
table to a "top 25". Any suggestions?

AFSSkier

how do I get a top 25 on a pivot table in excel 2007

Peter,

Click the filter button just like you would filter on a category. Than
Value filters, Top 10 is defaulted, enter new value (25).
--
Kevin

"Peter" wrote:

In a pivot table in excel 2003 I have no problem generating a "top 25" in a
pivot table. But I'm having a problem in excel 2007 restricting my pivot
table to a "top 25". Any suggestions?

All times are GMT +1. The time now is 05:13 AM.