View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
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