using 'fill right' to copy formulas in a pivot table, keeping some data elements constant

[jfeinstein]

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