LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 516
Default GETPIVOTDATA help

I'm trying to create a conditional field for getting pivot data - for
example, if it is week 1, it will grab the pivot data for week 1 and the
specfic data of interest. I also want to get the grand total amount, but it
doesn't seem to be working when I try to pull that value even though the
condition is met - how is it referenced in get pivot function?


 
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
GETPIVOTDATA Excel 2003 Problem Randall Excel Discussion (Misc queries) 7 August 27th 06 04:07 PM
GETPIVOTDATA with an Array Steve Excel Worksheet Functions 0 August 7th 06 02:41 PM
GetPivotData function returning N/A error for some rows Hari Excel Discussion (Misc queries) 1 May 15th 06 07:29 AM
GETPIVOTDATA Bug SthOzNewbie Excel Worksheet Functions 1 April 3rd 06 08:05 AM
Copy GetPivotData Outside Report Elaine Excel Worksheet Functions 3 April 11th 05 03:35 AM


All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"