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.
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.