![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
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 |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot table help | TishyMouse | Excel | 2 | 04-27-2012 10:19 AM |
![]() |
aliasadi_07 | Excel | 1 | 03-11-2012 12:49 AM |
![]() |
natsha | Excel | 1 | 02-16-2012 12:41 PM |
![]() |
Karen615 | Excel | 5 | 08-03-2011 10:46 AM |
Pivot Question | rejubinu@gmail.com | Excel | 1 | 01-21-2011 02:25 PM |