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.

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