How to get data from pivot table with multiple column fields?

[RADO]

I have a pivot table (excel 2002) with several column fields. It looks like
this:
Category 1
Subcategory A Subcategory B
......

I would like to be extract data from one column, say Subcategory B,
programmatically. How can I do that?

I tried to use GetPivotData, but could not figure out how it works.

Thanks -

RADO

 

[Dick Kusleika]

RADO

If you want the total of SubCat A, then you would use

=GETPIVOTDATA(A1,"Category 1 Subcategory A")

If you had a row for RADO and you wanted RADO's numbers for Subcategory B,
you would use

=GETPIVOTDATA(A1,"RADO Category 1 Subcategory A")

The A1 is any cell that's in the pivot tables. The name portion is like a
path to the data separated by spaces.

 

[RADO]

Thanks - that helps!
RADO

RADO

If you want the total of SubCat A, then you would use

=GETPIVOTDATA(A1,"Category 1 Subcategory A")

If you had a row for RADO and you wanted RADO's numbers for Subcategory B,
you would use

=GETPIVOTDATA(A1,"RADO Category 1 Subcategory A")

The A1 is any cell that's in the pivot tables. The name portion is like a
path to the data separated by spaces.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

 

[tmagdy]

I believe you will have to add single quotes to the fields that hav
more than 1 word. e.g. "'Field 1' 'Field 2'