Sort / Show Top 25

R

Rudy Guerrero

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
 
A

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


Rudy Guerrero said:
I have created a pivot table that displays large amounts of data. I would
Click to expand...
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.
 
Top