![]() When you added the TotalPrice field, Excel automatically added it to the Values area, and used the Sum function to summarize the prices. Table, in the Values area, as Sum of TotalPrice.Įxcel added the TotalPrice field to the Values area because it is a number field. The TotalPrice field is automatically added to the pivot.In the PivotTable Field List, add a check mark to the TotalPrice.In this example, we'll add the TotalPrice field to the pivot table. ![]() You can change the layout of the pivot table, after it's been created.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |