Forum Discussion
Maddissonleigh
Mar 23, 2020Copper Contributor
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 ...
Maddissonleigh
Mar 23, 2020Copper Contributor
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.
Savia
Mar 23, 2020Iron Contributor
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?
- MaddissonleighMar 23, 2020Copper ContributorI 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.
- Charla74Mar 23, 2020Iron Contributor
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...
- MaddissonleighMar 23, 2020Copper ContributorGot it! Thanks everyone!