Sort / Show Top 25

[Guest]

I have created a pivot table that displays large amounts of data. I would like to know how to only show the top 25 values and sort the data in descending order. It is easy to do in Access but I do not know how to do it with VB.

Thanks for the help

Rudy

 

[Alex Dybenko]

well, i think the same like in access - use select top 25

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

I have created a pivot table that displays large amounts of data. I would

like to know how to only show the top 25 values and sort the data in
descending order. It is easy to do in Access but I do not know how to do it
with VB.