Further, Grand Total column and Grand Total row are displayed for subtotals field-wise in rows and columns respectively. In the PivotTable, in the top-left corner, Sum of Order Amount is displayed. SumĬonsider the following PivotTable wherein you have the summarized sales data regionwise, salesperson-wise and month-wise.Īs you can observe, when you drag the field Order Amount to ∑ VALUES area, it is displayed as Sum of Order Amount, indicating the calculation is taken as Sum. In this chapter, you will learn how to set a calculation type based on how you want to summarize the data in the PivotTable. However, you have other calculation types, such as, Count, Average, Max, Min, etc. By default, Excel takes the summarization as sum of the values of the field in ∑ VALUES area. You can summarize a PivotTable by placing a field in ∑ VALUES area in the PivotTable Fields Task pane.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |