Pivot Tables

Hi Paul,

For a particular set of data I receive every month, I need to create a pivot table. Once I set up the appropriate rows, I need to add quite a few items into the "values"/"data" area of the pivot table. Everytime I do that, rather than showing the values themselves as "sum", the data appears as "count". For each column, I then need to right click, choose "value field settings", then deselect "count" and choose "sum".

To answer your question, it seems like count is the default selection, which I have to override for every column of data I have selected to show in my pivot.

Does this help provide a more clear explanation of my issue.

Best, Zayd