Pivot Tables - delete rows from Master List
pivot reports are a view if you will, on the underlying master table.
so yes, you are correct.
however, double clicking one of the pivots extracts the raw data which isn't
dependent on the master table
"mathel" wrote in message
...
I have a workbook with 3 worksheets. One is a Master list, and the other
2
are Pivot Tables (called Under 10k & Over 10k).
Once I have done the Pivot report, I no longer need the data in the rows
from the Master list. However, I find that if I delete the rows, the
Pivot
Table is reverting to 1 line with no data.
Am I assuming correctly that no data should be eliminated from the Master
List in order that the Pivot Tables filter properly?
--
Linda
|