Pivot counting error

R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top