How to use pivot table to get a value by multiplying two different datas

phs90

New Member
Joined
Oct 17, 2013
Messages
1
Hi everyone. I am now working on how to use pivot table calculate revenue (by multiplying volume and price) of the company. For now, I have combine two data sheets which are volume sheet and price sheet and hence create a pivot table. But at the column field there it can only show volume or price of the year. Even the value field settings only have sum, count, average... but do not have product (multiply function) How do I make the column field to have revenue of the year?

Thanks a lot.
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top