LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
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 02:41 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"