Forum Discussion
Pivot Table Summing ID Number
I am trying to make a Pivot Table, but my ID number keeps being summed. I changed the column to not be read as a number, rather as text - but it continues to sum the ID Number. Any suggestions on how ...
Hello, as correctly said by Savia, you should not drop your ID field inside the Values area. If you do so, PivotTable will do it's job which is to summarize numeric values that comes into the values area.
If you want ID to appear in your report, it is always recommended to have such dropped inside the Rows area
That feature isn’t an option when creating a pivot table on my machine. It is windows 10 OS and I’m thinking an issue with the OS? I tried what you suggested on my Mac, but it’s not working on my windows machine.
Maddissonleigh It's a standard option in Pivot Tables since the 90s so I don't think it's a version problem. What is happening when you are trying to set it up this way?
- I go to create a pivot table and it selects each column like it should. Then I go to add in the sections and it automatically sums ID Number. I made sure to change that field to “text” so it shouldn’t sum. I figured out how to change the type of calculation, but I want no calculation.
Right click on the pivot table, select 'show field list' and from the panel which appears on the right, you should be able to drag / drop the ID field from Values into Rows...
