Hello:

I'm using Excel 2007, and a really nice and smart person in this newsgroups
area taught me just now how to create pivot tables.

But, I don't see of a way in the pivot table how to do top 10 analysis.
When I right click on the criteria, there is no top 10 list selection.

How do you do this sort of top 10 analysis in Excel?

Thanks!

childofthe1980s

I don't use 2007, but I'll tell you how to do it in Excel 2003:
Double-click in the row fields area, click Advanced Top Ten AutoShow On.
Maybe it is similar in 2003? How different can it be?

Regards,
Ryan--

--
RyGuy


"childofthe1980s" wrote:

Hello:

I'm using Excel 2007, and a really nice and smart person in this newsgroups
area taught me just now how to create pivot tables.

But, I don't see of a way in the pivot table how to do top 10 analysis.
When I right click on the criteria, there is no top 10 list selection.

How do you do this sort of top 10 analysis in Excel?

Thanks!

childofthe1980s