| 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.  
|
|
#2
|
|||
|
|||
|
hi eagarcia,
you need to take sum of NET AMOUNT in the Pivot table(@ Values box) becasue u took sum transaction Id' which is text Quote:
|
|
#3
|
|||
|
|||
|
Quote:
I originally had net amount, gross amount, etc... I guess after I fixed the text to number issue I put in the wrong field for value... That fixed it, thanks! |
| Reply |
| 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 | |||
Linear Mode
