Forum Discussion
Pivot table
Can I make changes in the pivot table, like sum? if yes, how? if no, why not?
I changed the values to numbers but still, I'm not getting the sum. Instead, I get a notification saying "You can't make changes to a pivot table".
https://1drv.ms/x/s!Ann8pObXbvKkk2_YdcO0y1ZDfI3q?e=kbotfP
I can change from "Count" to "Sum". However all results are 0.
That is because D4:D7 is text and not number. Check with ISTEXT() or ISNUMBER().
The reason is the cells contain a dollar sign and several blanks. Remove them.