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

  • Thread starter Thread starter RADO
  • Start date Start date
R

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
 
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.
 
Thanks - that helps!
RADO


Dick Kusleika said:
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.
Click to expand...
 
I believe you will have to add single quotes to the fields that hav
more than 1 word. e.g. "'Field 1' 'Field 2'
 
Back
Top