Pivot Table - Subtotal of 3 columns

[kaon]

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

 

[Tom Ogilvy]

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.