Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-24-2014, 01:53 AM
divya divya is offline Multiplication in pivot Windows XP Multiplication in pivot Office 2010 32bit
Novice
Multiplication in pivot
 
Join Date: Sep 2014
Location: bangalore
Posts: 1
divya is on a distinguished road
Unhappy Multiplication in pivot

I have to two columns in pivot i want to multiply these two colomns.



Kindly let me know the procedure of how to do the Multiplicaion in Pivot

Regards
divya sridahr
Reply With Quote
  #2  
Old 10-23-2014, 01:23 PM
themausman themausman is offline Multiplication in pivot Windows 7 32bit Multiplication in pivot 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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table help TishyMouse Excel 2 04-27-2012 10:19 AM
Multiplication in pivot pivot table aliasadi_07 Excel 1 03-11-2012 12:49 AM
Multiplication in pivot Help with a pivot table please! natsha Excel 1 02-16-2012 12:41 PM
Multiplication in pivot Pivot Table Karen615 Excel 5 08-03-2011 10:46 AM
Pivot Question rejubinu@gmail.com Excel 1 01-21-2011 02:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft