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

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

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

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.

"RADO" wrote in message
...
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

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

Thanks - that helps!
RADO


"Dick Kusleika" wrote in message
...
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.

"RADO" wrote in message
...
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

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

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com