Pivot Table Multiple Summary functions

V

Vinod

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top