Removing Pivit Table Items

[Dave]

I'm way over my head here, so bear with me -

I have a pivot table for prescription drug charges. The ROW column has the
12 months. When I first set this up, there were several other subheadings
(drug store/size/etc.) which appeared, correctly, after the 'months'
listing.

I have now revised the chart so that all I want are the 12 months. However,
try as I might, the old subheadings persist in appearing in the row list.
In addition, a couple of new items have appeared, as far as I know out of
thin air - 'formula1" and 'blank'

How can I delete these extraneous items. They don't appear anywhere in my
base data.

Thx
Dave

 

[Shane Devenshire]

Hi,

What version of Excel are you using?

In 2003 and earlier, you can remove a new field by dragging it off the pivot
table. (drag the field button at the top of the column off the pivot table)

If it is not a field but an item, then open the filter for the field and
uncheck the items you don't want to see.

By default if an item ever existed in a field it is retained on the filter
list. If you want to clear the list, not just hide the item, drag the field
button off the pivot table, click the Refresh button, and drag the field
button back on to the pivot table.

 

[Dave]

Thank you Shane -
Office (Exell) 2003

I would like to remove the extraneous items from the field list, but when I
drag the field button off/refresh/replace they are still there.

What to do?
Dave