PDA

View Full Version : Delete data from Pivot Table



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

JWhite
04-15-2011, 05:53 AM
The pivottable doesn't contain any data. It's just a report based on whatever is in the pivotcache. You can have multiple pivottables (reports) from one pivotcache. Each pivottable can have different filters, rows, columns, sort sequences, etc., but they all come from the same data source - the pivotcache.

All the data is in the pivotcache and I don't think there's any way to manipulate data in the pivotcache itself, except when you create the pivotcache.

So, in answer to your question, if the data exists in your pivotcache and you don't want it to appear in the pivottable, the only way to eliminate data from a pivottable is to filter it.

reza_doang
04-18-2011, 01:06 AM
Jwhite...

oh i see...
thanks for your response