![]() Click on the Summary Function that you want to use.In the pop-up menu, click Summarize Values By.Right-click on a cell in the Value field that you want to change.The default function can't be changed - it is applied based on the field's contents:Ĭontains numbers, Sum will be the defaultĬontains text or blank cells, Count will be the defaultĪfter a field has been added to the pivot table, to select a different summary function, follow When you add a numerical field to the pivot table's Values area, ![]() The summary functions in a pivot table are similar to the worksheetįunctions with the same names, with a few differences as noted in When you add a field to the pivot table's Values area, 11 differentįunctions, such as Sum, Count and Average, are available to summarize
0 Comments
Leave a Reply. |