Pivot Table to return Max, Avg, Last

[adept]

I need to extract data from a large table of item usage. What I would like is the Max (largest amount stocked), Avg usage, Last (from last stock, date lookup). I have three Pivot tables doing the job now.

Is is possible to only use one and have three columns for each of the desired results?

I am having trouble with automating the selection of the Pivot Table data. See http://www.mrexcel.com/forum/showthread.php?p=1867876#post1867876

Thanks gang!

Craig