How to extract aggregate values from PivotTable

I

Ivanchain

Hi, friends. Please look this:

I know there is an article answered this question at
http://support.microsoft.com/kb/q294782/. But I still want to know how to
extract aggregate value in a cell when columnmember is null.

For example: drag a measure into the datafield, drag a dimemsion into the
rowaxis field, but keep the columnaxis field to be empty. Now, I try to
extract the measure cell's aggregate value by" CellValue =
AxPivotTable1.ActiveData.Cells(RowMember, ColumnMember).Aggregates(0).Text",
just like the kb 294782 said. But, now it will report an error, because there
is NO columnmember now.

But the AxPivotTable1.ActiveData.Cells() method need the columnmember
parameter, and if I send nothing to it, also get an error.

What I need to do?
Thanks,
Ivan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL - As part of an aggregate function ERROR 6
Programmatically reading data field values from PivotTable 2
aggregate functions 3
Aggregate MEDIAN 2
How to Find(...) in different worksheets with VBA? 2
aggregate 6
Pivottable problem 1
Create Aggregate function 5

Top