reza_doang
04-14-2011, 12:43 AM
dear all,
Can i delete data from pivottable?
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? because i have many data that should i delete...
Many thanks for your assistance
reza
Can i delete data from pivottable?
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? because i have many data that should i delete...
Many thanks for your assistance
reza