LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les Les is offline
external usenet poster
 
Posts: 240
Default Getting result from a Pivot Table - Question

Hi all,
i have a pivot that i get data from. I am using the following.

=GETPIVOTDATA("Sum of Initial year savings",'Projects per Qtr'!$A$3)

This gives me the result of the pivot on certain criteria e.g. Q1/08, Q2/08,
Q3/08 & Q4/08 if they are all selected.

Is it possible to get the 2007 results if not selected with the pivot, via
code ??

--
Les
 
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
extract row number from Pivot Table Result gtslabs Excel Worksheet Functions 1 April 1st 09 04:47 AM
Add result feilds to a pivot table Aaron Excel Programming 3 August 13th 07 06:39 PM
Pivot table strange result prufrock Excel Discussion (Misc queries) 0 February 23rd 07 04:40 PM
HELP PLEASE! - APPLYING A % COLUMN TO A PIVOT TABLE RESULT Pete Excel Discussion (Misc queries) 1 February 5th 07 10:42 PM
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question Barb Reinhardt Charts and Charting in Excel 3 December 8th 04 01:48 AM


All times are GMT +1. The time now is 10:39 PM.

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"