![]() ![]() The PivotTable will display the minimum values region wise, salesperson wise and month wise. The Custom Name changes to Min of Order Amount. In the Summarize value field by box, click Min. Suppose you want to summarize the PivotTable by the minimum values of Order Amount region wise, salesperson wise and month wise. Both the Column and Row headers will change to Max Order Amount. Type Max Order Amount in the formula bar. The PivotTable will display the maximum values region wise, salesperson wise and month wise.Ĭlick on the header the Grand Total column. The Custom Name changes to Max of Order Amount. In the Summarize value field by box, click Max. Suppose you want to summarize the PivotTable by the maximum values of Order Amount region-wise, salesperson-wise and month-wise. Both the Column and Row headers will change to Average Order Amount. Type Average Order Amount in the formula bar. The PivotTable values will be formatted to numbers with two decimal places.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |