Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table multiple column fields | Excel Discussion (Misc queries) | |||
Returning to multiple data fields pivot table view | Excel Worksheet Functions | |||
Drag multiple fields into data of pivot table | Excel Worksheet Functions | |||
Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
Can I pivot multiple data fields and display them in a column? | Excel Discussion (Misc queries) |