Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-19-2016, 12:15 PM
jfeinstein jfeinstein is offline using 'fill right' to copy formulas in a pivot table, keeping some data elements constant Windows 7 32bit using 'fill right' to copy formulas in a pivot table, keeping some data elements constant Office 2010 32bit
Novice
using 'fill right' to copy formulas in a pivot table, keeping some data elements constant
 
Join Date: Dec 2016
Posts: 5
jfeinstein is on a distinguished road
Default using 'fill right' to copy formulas in a pivot table, keeping some data elements constant

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
Reply With Quote
 

Tags
formulas, pivot tables



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table - Copy Rows theexpat Excel Programming 0 02-26-2016 08:14 AM
using 'fill right' to copy formulas in a pivot table, keeping some data elements constant Data not showing in Pivot Table MichelPierre Excel 2 01-26-2016 10:51 AM
Pivot Table Duplicate Data cnw Excel 0 08-31-2012 08:24 AM
using 'fill right' to copy formulas in a pivot table, keeping some data elements constant Keeping the top row constant in Excel MSmand Excel 2 07-13-2011 01:14 PM
using 'fill right' to copy formulas in a pivot table, keeping some data elements constant Using subtotals in Pivot table formulas ninfanger Excel 3 10-23-2010 12:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 PM.


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