Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Pivot Table 2003 - Creat a column using absolute cells o/s the tab

How do I create a column within the Pivot Table that will access absolute
cells outside the table but within the same worksheet.

The Pivot table gives me a count of hours by person and now I need to create
a column that will show total cost of those hours using rates that I have
created in cells with an absolute rate outside the table.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default Pivot Table 2003 - Creat a column using absolute cells o/s thetab

You can't refer to cells outside the pivot table when creating formulas
in a pivot table. Perhaps you can enter the rates in the source data,
and do the calculations there. Then add the calculated valued to the
pivot table.

Ed Bonk wrote:
How do I create a column within the Pivot Table that will access absolute
cells outside the table but within the same worksheet.

The Pivot table gives me a count of hours by person and now I need to create
a column that will show total cost of those hours using rates that I have
created in cells with an absolute rate outside the table.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creat table list Learners of excel, access and databases Excel Discussion (Misc queries) 2 July 12th 07 11:04 AM
Pivot Table Q: Creat using fieldA valueB OR fieldC valueD? Jan K Excel Discussion (Misc queries) 2 February 20th 06 02:34 PM
pivot table : formula to absolute reference a subtotal fax Excel Discussion (Misc queries) 2 November 19th 05 09:28 PM
Can links between Excel 2003 Pivot Charts and their pivot table b. Mark Allen Charts and Charting in Excel 2 March 5th 05 05:24 PM
Pivot tables Excel 2003 absolute references Poj Excel Discussion (Misc queries) 2 January 25th 05 12:57 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"