I have raw data that looks like this:
ID Created Date Item
280101 1/2/2015 0:00 Apples
280102 1/5/2015 0:00 Oranges
280103 2/2/2015 0:00 Bananas
280104 2/9/2015 0:00 Pears
280105 2/18/2015 0:00 Peaches
280106 2/19/2015 0:00 Clemintines
280107 2/24/2015 0:00 Pears
280108 3/2/2015 0:00 Bananas
280109 3/9/2015 0:00 Apples
280110 4/2/2015 0:00 Apples
280111 5/6/2015 0:00 Oranges
280112 5/8/2015 0:00 Pears
280113 5/9/2015 0:00 Lettuce
280114 5/15/2015 0:00 Kale
280115 5/15/2015 0:00 Lettuce
280116 5/15/2015 0:00 Bananas
280117 5/19/2015 0:00 Oranges
280118 6/2/2015 Bananas
280119 6/19/2015 Pears
280120 7/2/2015 Peaches
280121 12/14/2015 Clemintines
280122 12/15/2015 Pears
280123 12/16/2015 Bananas
280124 12/18/2015 Apples
280125 1/2/2016 Apples
280126 1/3/2016 Oranges
280127 1/4/2016 Pears
280128 1/8/2016 Lettuce
280129 1/19/2016 Kale
280130 2/2/2016 Lettuce
280131 2/4/2016 Bananas
280132 2/15/2016 Oranges
I'm trying to pull a list that will show the Top 5 Items by year/month. End result would look like this, month/year in columns with top 5 for each month below:
2-10-2016 10-47-54 AM.png
Then I'd try to add count of each and percentage of total if possible too?
I've attached my sample Excel document:
Book1.xlsx
Bookmarks