Hello,
I would like to show the top ten sales values for a year. There are about
60 sales values for 2003 in the database, as well as values for other years.
When I use auto filter and filter for the year 2003 I get only 2003 records.
That's fine. But when I use the top ten filter on the Sales values I get
only five records, not the top ten for the year 2003, as expected. I think
Excel is using all the records, including other years and only displaying
2003.
Is there a way to get the top 10 2003 records?
Thanks for any help.
Jake