Pivot Changes when refreshed with the same data

S

SD

Hello ,

I am just not able to find out why my data is changing.

I had created a Pivot from a dataset. The numbers matched. I saved
it. When I opened the pivot after a couple of days , I added a
conditonal FLAG column in the dataset so that I could bring that
condition to the Pivot. I only refresh the Pivot to get the new
variable name added, however most of the data changes, I do not why.
Numbers are intact, and fearing I would lose the effort I do not save
it. I close it and open the original file. When I double click on any
cell of column I get around 80 rows. When I refresh it and double
click on the same cell on the pivot I get 160 rows. Now how is this
possible ? is it because I added a column in the data set ? Say
Columns A to G are in the data set. I saw column E blank so I added my
conditional flag in there so that I do not have to again change the
range. Is it because of this ? Now how do I get it back or is there a
work around this ? Do I need to start all over again :(((

Appreciate any help.

thanks
SD
 
Top