Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KD KD is offline
external usenet poster
 
Posts: 41
Default Getpivot calulation

Does anyone know how to drag a getpivot caulation to other cells, instead of
having to type into each individual cell?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default Getpivot calulation

Hi

Where the GetPivotData shows the field name in the calculation, change
that part of the reference to the cell value on the PT where the Field
name appears.

--
Regards

Roger Govier


"KD" wrote in message
...
Does anyone know how to drag a getpivot caulation to other cells,
instead of
having to type into each individual cell?



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
Getpivot date w/ relative reference Spidey Excel Worksheet Functions 8 November 14th 06 04:34 PM
cancelling getpivot formula when setting formula outside pivot ta. cancelling getpivot formula Excel Worksheet Functions 2 October 31st 06 10:31 PM
GETPIVOT DATA HELP - PLEASE!!!! Matt Excel Worksheet Functions 2 October 17th 06 10:12 PM
Disable automatic GETPIVOT news.microsoft.com Setting up and Configuration of Excel 3 July 10th 06 09:19 PM
Disable automatic GETPIVOT news.microsoft.com Excel Worksheet Functions 3 July 10th 06 09:19 PM


All times are GMT +1. The time now is 11:12 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"