If you click on the dropdown arrow in the Row Labels cell, you can sort the rows and also hide/show any of them. And that’s it! You’ll see that both these fields have been added to the blank pivot table and the Inventory has been summed up according to category! Just select Category and Inventory fields from the Choose fields to add to report box. Can pivot table answer this question? Yes, of course! And you would be surprised how easy it is! Similarly we want to know the sum for all the movie categories. For example, we want to know how many CDs we have under the Action category. Let’s say, we want to know the total number of movie CDs we have under each category. Before we do that, we need to understand what we want from our pivot table. Now that we have created a blank pivot table, it is time to add required fields in this table. The term Pivot Table (with a space) is a generic term and any software or vendor can use it but PivotTable™ is a trademark of Microsoft Corporation in the United States. The reason is that Microsoft uses the compound word PivotTable as a trademark. NOTE: You may be wondering why Excel does not show a space between the words “Pivot” and “Table”. Don’t worry, it’s one and the same thing! Please note that you may get this PivotTable Field List either as shown in the following image OR it could also appear docked on the right edge of the screen. Besides blank pivot table, you will also see the PivotTable Field List dialog box.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |