Pivot counting error
 

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

Pivot counting error
 

Never mind folks..
"R" wrote in message
...
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