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...
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.
Reply With Quote
