![]() |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
how do I build a formula in a pivot table such that when I 'fill right' it will adjust appropriately for each column. NOTE: I have two levels of values in the row headings. The formula I am using is:
=(GETPIVOTDATA("Count of Clinicians",$A$3,"MONTH","Feb","DURATION (minutes)",30)*$A$6)+(GETPIVOTDATA("Count of Clinicians",$A$3,"MONTH","Feb","DURATION (minutes)",45)*$A$7)+(GETPIVOTDATA("Count of Clinicians",$A$3,"MONTH","Feb","DURATION (minutes)",60)*$A$8)+(GETPIVOTDATA("Count of Clinicians",$A$3,"MONTH","Feb","DURATION (minutes)",75)*$A$9)+(GETPIVOTDATA("Count of Clinicians",$A$3,"MONTH","Feb","DURATION (minutes)",90)*$A$10)+(GETPIVOTDATA("Count of Clinicians",$A$3,"MONTH","Feb","DURATION (minutes)",180)*$A$12)+(GETPIVOTDATA("Count of Clinicians",$A$3,"MONTH","Feb","DURATION (minutes)",960)*$A$13) My pivot table looks like this: Feb Duration Count of Clinicians Count of PCPs Count of MAs 30 45 1 1 1 60 75 1 90 1 180 960 135 135 Hours by Title 2.25 |
Tags |
formulas, pivot tables |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Table - Copy Rows | theexpat | Excel Programming | 0 | 02-26-2016 08:14 AM |
![]() |
MichelPierre | Excel | 2 | 01-26-2016 10:51 AM |
Pivot Table Duplicate Data | cnw | Excel | 0 | 08-31-2012 08:24 AM |
![]() |
MSmand | Excel | 2 | 07-13-2011 01:14 PM |
![]() |
ninfanger | Excel | 3 | 10-23-2010 12:29 AM |