Pivot Tables and extracting data

[Tarheel]

Hi all,

I frequently download LARGE volumes of data (12 to 14 MB) that have to do with items my company sells. I use a pivot table to group the items by item ID, date sold, qty sold, etc.

What I don't understand, is how to extract the TOTAL information from the Pivot Table in a quick and efficient manner. Each item # has a TOTAL line for each day in the reporting period, and then a TOTAL line for the entire reporting period. But that data is all in one column, and there can be up to 30 days and over 125 different items.

Anyone have any ideas?

Thanks!

 

[TommyGun]

Look up GETPIVOTDATA in the Excel help file. This formula will pull information from a pivottable based upon a string description.

=GETPIVOTDATA(a4,"March Texas Produce")

 

[Tarheel]

Thanks so much, Tommy. This looks perfect!

Best regards,
Richard