Next, choose the fields to add to the report. Your pivot table should now appear as follows: In this example, we've chosen cells A1 to F16 in Sheet1. Select the range of data for the pivot table and click on the OK button. In the Tables group, click on the Tables button and select PivotTable from the popup menu.Ī Create PivotTable window should appear. Next, select the INSERT tab from the toolbar at the top of the screen. In this example, we've selected cell A1 on Sheet2. Highlight the cell where you'd like to see the pivot table. 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.Question: How do I create a pivot table in Microsoft Excel 2013?Īnswer: In this example, the data for the pivot table resides on Sheet1. 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.
0 kommentar(er)
