How to extract aggregate values from PivotTable
 

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

How to extract aggregate values from PivotTable
 

hi, does anyone see it?



"Ivanchain" wrote:

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