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
|