Pivot table count error

[R]

Hi,

So I have a unique dataset based on some ID. I created a pivot table based
on this dataset and later went in to add a couple of more records.When I
refresh, I can see the new column created in the pivot table for the newly
added records but there is no change in the sum total which is very
worrisome becuase there should be since I have only unique records .....
e.g.

1. Original Pivot table
Unit
Total count of IDs

A
31

B
77

C
184

D
7

E
29

F
139

G
11

H
40

I
134

Grand Total
656



2. New unit added
Unit
Total count of IDs

A
31

B
77

C
184

D
7

E
29

F
139

G
11

H
40

I
134

J - new unit just added
4

Grand Total
656



The problem is that I have 660 unique IDs. Can someone please tell me what's
going on?

Thanks,
-R

 

[R]

I just discovered that the pivot table is dropping another unit and
replacing it with the new entry.

Any ideas there?