Thread: [Solved] Multiplication in pivot
View Single Post
 
Old 10-23-2014, 01:23 PM
themausman themausman is offline Windows 7 32bit Office 2010 32bit
Competent Performer
 
Join Date: Oct 2014
Location: the Netherlands
Posts: 144
themausman is on a distinguished road
Default

add a calculated field in your pivot. Goto the analyze tab, then to the calculations group. Choose Fields, items & sets.
Next choose Calculated feld

In the next dialog select the first field you want to use for your calculation and click insert field. Typ the * and then click your second field from the list. Choos add field and then click OK.

A new calculated column will automatically be added to your pivot table.

hth
Reply With Quote