Posted to microsoft.public.excel.worksheet.functions

Posts: n/a

GetPivotData need help

I am currently trying to get data from a pivot which has this form

Sum Count Block
False True Grand Total
item1 4 4 8
item2 3 3 6
item3 3 4 7

I am trying to get "item1" "Sum Count" "Block" "False" = 4

but sinceim using excel 2000 i am not sur how to uild my path string.
can someone please help me out ?

regards,
Alexandre Brisebois

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 Bug	SthOzNewbie	Excel Worksheet Functions	1	April 3rd 06 08:05 AM
calculate average for all of data field using GETPIVOTDATA?	andrew	Excel Worksheet Functions	0	February 21st 06 11:17 PM
"Best Practices" Use of GetPivotData Function	Johnny Meredith	Excel Worksheet Functions	0	December 12th 05 11:22 PM
Copy GetPivotData Outside Report	Elaine	Excel Worksheet Functions	3	April 11th 05 03:35 AM
Getpivotdata update issues?	Calgarychris	Excel Discussion (Misc queries)	0	March 30th 05 01:59 AM

All times are GMT +1. The time now is 08:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us