pivot table problem in excel

[rene65]

I have 3 columns. 1. filled with general ledger numbers (GLN), 2. amounts, 3. debet or credit. The first 100 rows were imported from access. the second 100 typed in. Upon making the pivot table it seems that a subtotal per unique GLN is made from the first 100 and a subtotal for the unique second 100.
It even puts the unique GLN from the first 100 to the far right of the cell and the unique GLN from the second 100 to the far left of the cell. Is it because of the imported cells or is it a bug ? I want a pivot table with unique GLN from the 200 rows with subtotals. Now I have duplicate GLN.
Please help.

 

[calculus]

1. Check to see if the cells imported from Access are set up as GENERAL format. Right click the cell and choose format cells.

2. Check to see if the imported cells actually have a "'" in front of the numbers. The fact that one set is left justified and the other is right justified tells me that Excel is seeing them differently. Solve this and your pivot table should work fine.

calculus

 

[xlbo]

I'm guessing that your unique values are "numbers"
In which case this is classic Numbers vs Numeric Text
What has probably happened is that the "numbers" brought in from access are actually text that looks like numbers
To solve this, go to the base data sheet that holds all the entries for the pivot table
Enter a 1 in a blank cell
Edit>Copy
Select ALL the entries in the GLN column
Edit>PasteSpecial
Choose multiply
All your textual numbers should be converted to actual numbers
Refresh the pivot table and all should be ok

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde