Zayd has attended:
Excel Intermediate course
Pivot Tables
How do I remove the automatic setting for "count" on the field settings?
RE: Pivot Tables
Hi, in field settings it is normally set to Sum, not count. Can you explain how you get the count? it is automatic or is it on a table you have inherited?
thanks
Paul
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
RE: 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
