Pivot Table Question - Using Calculations

[Tarball]

Given a simple Pivot table below. Dealer, Sales, and Units are in my source data. How can I programmatically build the Average Price colum in my Pivot Table. Average Price=Sales/Units

Please Login or Register  to view this content.

Thanks for the help.

Tarball

[Tarball]

Well I figured it out myself! Best way to learn is to read and do a little trial and error. For those of you who read this thread and have the same question...here is how to do it.

Please Login or Register  to view this content.

Enjoy