Pivot help please...

[alexandre.brisebois]

I am currently using excel 2000
and I am trying to read the pivot column headers, (Groups of data)

I currently can get the column fields,
but each on my column fields has sub categories,
I need to enumerate through these subcategories.
how do I read them ? how can I get how many columns a pivot table is
using?

Pivot --
|--- SUM TOTAL
|--- Part Family
|--- family 1
|---
total
|--- family 2
|---
total
|--- family 3
|---
total
|--- family 4
|---
total
|--- family 5
|---
total
|--- family 6
|---
total
|--- Grand Total
|---
total
I need to read the "family" level
- I currently can get the total trough getpivotdata
- I can get the 'Part Family'

best regards,
Alexandre Brisebois

 

[York]

If I understand your question correctly, you are going to an empty cell,
keying in an "=" sign and then clicking on a cell in the pivot table to
extract data.
That indeed will get the pivot data.
But..
Maybe you should try using the raw data as a Database instead of extracting
data from the P.T.
Then you can use database functions to extract what you want.

York

 

[Alexandre Brisebois]

well not really, im doing all this through vba,

at the moment I have a way to get the sub headers, but the problem is
that it gives me all the selected categories from the main header.
my pivot is paged, and I need to only get the header child items
meaning sub headers that are visible and filtered by the page headers.

if you need more precision please do ask, im really trying to get this
to work, and fighting against excel 2000. I cant wait to upgrade.

Best regards,
Alexandre Brisebois

 

[carimfam]

Hi Alex,

Did you take a look at following methods :
..PivotFields
..RowFields
..ColumnFields
these methods apply to PivotTable, and get you down to each element

HTH
Carim

 

[carimfam]

Hi Alex,

Did you take a look at following methods :
..PivotFields
..RowFields
..ColumnFields
these methods apply to PivotTable, and get you down to each element

HTH
Carim

 

[Alexandre Brisebois]

Yes I have taken a look at these properties
I would like to filter out what is not on screen hidden by page data,
at the moment I can get all the correct information but i get
everything even what is not visible,
but selected in the field.

alexandre brisebois