LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Calculating from a pivot table

I am trying to do a calculation outside of a pivot table using pivot table
data. The problem is that if I reference data inside the table the cell
references the calculation as through I was using an absolute cell reference
when I want a relative cell reference. How can I turn this off at the
worksheet level?
 
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
Calculating Percentages in Pivot Table GP Excel Discussion (Misc queries) 1 November 27th 06 10:16 PM
Calculating Geometric Mean in a Pivot Table Carrie Excel Worksheet Functions 0 August 14th 06 06:47 PM
Calculating the average of a sum in Pivot Table shysong Excel Discussion (Misc queries) 2 May 8th 06 09:51 PM
Pivot Table Calculating totals differently esparzaone Excel Discussion (Misc queries) 1 February 22nd 06 01:01 AM
Calculating % in a pivot table David Excel Worksheet Functions 1 March 13th 05 12:48 PM


All times are GMT +1. The time now is 12:59 AM.

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"