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

Dealer     Sales     Units     Average Price
Me           10         5             2
You         100        25           4

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.

   Dim PT As PivotTable

   . . .

   'Build Your Pivot Table

    With PT
      .CalculatedFields.Add "MY CUSTOM FIELD NAME", "=SALES/UNITS"
      .PivotFields("MY CUSTOM FIELD NAME").Orientation = xlDataField
      .PivotFields("MY CUSTOM FIELD NAME").NumberFormat = "$#,##0.00"
    End With

Enjoy