Extracting from Pivottables

J

John James

Is it possible/practical to extract data from pivottables (apart fro
pivotcharts) and if so how?

Pivottables are excellent in analysing, summarising and drilling dow
on data, but the subsequent presentation and use of that data appear
very restricted and manual based on my current knowledge.

Are there any relevant tricks or tips & if so where
 
J

John James

Thanks, Peo.

I hadn't considered using the drill-down facility for this type o
purpose. If the drill-down is more summarised than the original dat
upon which the Pivottable was based, then this has interestin
potential for summarising data through a quick, simple, low-erro
process.

Do you know whether the table produced is a summarised version of th
original data or if it retains all of the original detail? I'm hopin
it is summarised.

In any case, I suspect there might be some potential here because m
recollection is that the drill-down works on any figure in an
pivottable.

Cheers
 
Top