Pivot Table - Subtotal of 3 columns
 

Hi all,

Is it possible to display 3 subtotal columns on the rightmost of th
pivot table?

For example, now I have a pivot table with the following format:
Product Desc, Product ID, Unit Price, Revenue

now I added two more fields onto the table, i.e. :
Product Desc, Product ID, Unit Price, Revenue, Qty Bought, Qty Sold

But I found that I cannot do the subtotal seperately for the last
columns, is that any way to acheive that (or even by code)?

Thanks

--
Message posted from http://www.ExcelForum.com

Pivot Table - Subtotal of 3 columns
 

Only a single sum is done across the columns of the data fields (for each
row).

You can put in formulas to the right and compute your own subtotals.

--
Regards,
Tom Ogilvy




"kaon " wrote in message
...
Hi all,

Is it possible to display 3 subtotal columns on the rightmost of the
pivot table?

For example, now I have a pivot table with the following format:
Product Desc, Product ID, Unit Price, Revenue

now I added two more fields onto the table, i.e. :
Product Desc, Product ID, Unit Price, Revenue, Qty Bought, Qty Sold

But I found that I cannot do the subtotal seperately for the last 3
columns, is that any way to acheive that (or even by code)?

Thanks.


---
Message posted from http://www.ExcelForum.com/