pivottables

  • Thread starter Thread starter lennert
  • Start date Start date
L

lennert

hi,

I created a pivot from a dataset. This was no problem at all. In a
later stadium I changed the recordset where the pivottable is based on.
For example i replaced all the records containing pete into mike in the
column <NAME>. When refreshing the pivot it now contains both mike and
pete. Pete is redundant, because i no longer exists. How do I get rid
of it?.

lennie
 
Hi

Just drag the field out of the Pivot Table, then do a Refresh, then drag
it back again
 

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

Back
Top