Pivot tables

Hi Simran

Thank you for your question.
One fix is to double check the data prior to creating the Pivot table. Excel generally switches to Sum when the column of data contains text or spaces.

Make sure everything is formatted as a number and this should avoid the Sum function being selected in the pivot table.

Once in the Pivot table you will need to go to the respective Value Field Settings to switch Count to Sum so it's easier if you and get the data ready for pivoting first.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew