Delete data from Pivot Table

[reza_doang]

Dear All,

can i delete data from pivottable?
if yes..can someone teach me how? or maybe give me a link.
sample:
In Master Sheet i created Pivot Table to Pivot Sheet.
In Pivot Sheet, it will created summarize about data. Now i want to delete an unused data.
i.e
Row Labels Count Data
Task A 1000
T1 200
T2 150
T3 350
T4 300

when i see that data, T2 is unused data so i want to delete, rather that go to Master Sheet that i should used filter and delete it, can i directly delete from pivot table?

Many thanks for your assistance

reza

 

[Trevor G]

If you filter the data in the pivot then it wont show in the pivot table results so you would show all and then remove the tick for the data you don't want to see.

It may help if you let us know which version of Excel you are using.