Feb 20 2019 12:21 AM
I'm having an issue in my pivot table when I sum a column it says the total is zero (when in the data it is not zero) but in the count numbers are appearing. The format of the data in the sheet is "General" evem though it looks like it should be currency and has $ signs before the actual numbers. Can someone please help?
Feb 21 2019 07:14 AM
If you =ISTEXT() on any of such cells in your sources table does it return FALSE?
Feb 21 2019 07:31 AM
You need convert them to numbers. If your column now in General format try Ctrl+H and replace all $ characters on nothing.
Feb 25 2019 04:56 AM
Great, thank you!!! It works now :)