Refreshing Data within a pivot table

[KeithB]

I have downloaded a sales order file approx. 14,000 lines of data and I am
using pivot table to review qtrly sales of different parts. The pivot table
has returned data as expected but there is a qty against a blank field that
should contain the part number. Within the raw data the part field for
repairs was blank (Explaining my problem) so I have gone back and and typed
repair into the data source and then hit the refresh data button on the pivot
table. The update is still not pulling in the correct totals - any ideas

 

[Roger Govier]

Hi Keith

You do not say what the difference is. Has the total for the Part number
you typed increased? Is it that it is just still showing Blank as one of
your field?
Try dragging the Part number field out of the PT, do a Refresh, then
drag it back to the PT again. The dropdown list tends to still hold
names of fields that are no longer used. This operation clears the list.
It should not affect total numbers counted however.

If this doesn't work, post back with more details.

 

[KeithB]

Roger,

thanks - I have discovered the problem - I was using a single filter to
confirm that there were no blank fields in the Part Number field on the raw
data - I'm not sure what the limit on the number of options can be displayed
- there are 3000 unique part numbers - but "blank" & "non blank" were not
appearing as options within the filter criteria - however by applying more
filter fields I discovered that I had not picked up all of the blank fields
in Part number. Hope this makes sense and thanks again for your prompt
response