Is there a way to use pivot tables or some other mechanisms to "get" the top five results for each year of a multiyear list.
The dataset includes in column A the date and in column B the item. The data set covers 10 years worth of items. I need to know the top five items for each year.
Using pivot tables, I know I can get the top five items for each year, but I would need to change the filter for each year in order to cover the ten years. And then cut and paste the information into another table to "create" the master table showing the ten years of data.
In the end I am looking for something like this:
2002 2003 2004 2005...
1 1 1 1
2 2 2 2
3 3 3 3
4 4 4 4
5 5 5 5
Additionally I will need to know the count of each item (to know the how many times an item appeared in each year)
Attached is a file for ONE of the criterias that I am analysing (countries) that appear in the dataset. I need to do the same for three other criterias.