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

Thread Tools
Display Modes


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:59 AM.


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