Pivot tables can dramatically increase your efficiency in Excel. Grab the sample data and give it a try. Learning Pivot Tables is a skill that will pay you back again and again. If you need to be convinced that Pivot Tables are worth your time, watch this short video. With very little effort, you can use a pivot table to build good-looking reports for large data sets. You can then select which quarters to include by ticking/ unticking them in the 'Pivot Table Fields' section, but note that this will also affect the pivot table you picked to make into a pivot chart.Pivot tables are one of the most powerful and useful features in Excel. You can make a pivot chart by simply clicking the pivot chart button when you have a pivot table selected. To get the top ten you would either count the rows manually, or use formulae to present this on another worksheet. If you want all four at the same time then make four pivot tables. Then 'Descending (Z to A) by:' pick 'Sum of QTR1', then 'Sum of QTR2', etc. To get the top 10 per quarter you would need to click the arrow in the 'Row Labels' cell and pick 'More Sort Options'. You would wants your rows to be 'Category Association', and then you could add 'QTR1' to 'QTR4' as 'Sum of' items to the 'Values' part of the Pivot Table. If your data was in an Excel worksheet then you could easily make this into a Pivot Table, simply highlight all the data and Insert - Pivot Table.

I'm going to take a guess that you don't have an answer yet because this is poorly tagged?Īnyway, here's a quick stab, seeing as nobody else has stepped up to the plate yet.

Excel 2013 create pivot table