Pivot Table Multiple Summary functions
 

Hi All,

I have a report which contains data for 12 months of Sales. My data includes
these headers like, Product ID, Sales (Units), Sales ($), Unit Price ($),
Month and Quarter.

I generaed a report using Pivot Table and its layout is as follows...
'Product ID' at Row, 'Sales (Units), Sales ($), Unit Price ($)' at Data and
Quarter, Month at Column.

Finally my report is displaying summary at each quarter (3 months) by
performing 'Sum' function for Sales (Units), Sales ($), Unit Price ($).

But my requirement is, I wanted Summary should perform 'Sum' calcuation for
Sales (Units), Sales ($) and 'Average' for Unit Price ($).

Please help me in my requirement, it would be appreciated.

Advanced Thanks,
Vinod.