| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
All 0's on Pivot Table Sum, Data NOT text
I'm trying to download my PayPal transactions and turn it into usable data...
So far, I've turned the data into a table and can at least use the category drop downs. What I'd like to do, is create a pivot table to show sums of money received, and money sent out for fees, shipping, etc. Here are a couple of screen shots to show what I'm talking about. I've highlights some numbers to show they're not text and actually sum.  
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting text data from a pivot table | Excel Worksheet Functions | |||
| using pivot table to crosstab text value data | Excel Discussion (Misc queries) | |||
| text in data area on pivot table | Excel Discussion (Misc queries) | |||
| Pivot table - Text in Data field | Excel Discussion (Misc queries) | |||
| Text data appears as 0 in my Pivot table - how do I display as tex | Excel Worksheet Functions | |||
Threaded Mode
