cell value without columns, driving me mad

[Ivanchain]

Alvin, could you please look at this?

How to get a cell value without columns in a pivottable?
I know the totals object, and I use the
pivottable.activedata.cells(rowmember,columnmember).aggregates(n).text to
retrieve the cell value.

But, when there is no columns in table, what I need to do?
Please help this, really drive me mad.

Thank you.

 

[Alvin Bruney [ASP.NET MVP]]

I'm confused. You have a pivot cell with no columns? Columns are implicit in
the pivot table, so are rows.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99

 

[Ivanchain]

Yes, I have a pivot table without columns, just drop nothing into the columns
field(keepping it empty), and drag some measures into the data field, you
will see the situation.

But, I have found the answer allready. there is a dummy member in the
columnaxis property, "ColumnAxis.Member", I could send it as the columnmember
parameter of the cells() method, and it works.

Thank you anyway.
I want to buy the blackbook, but, I can't find it. I am in China, and I
couldnot found it on the www.amazon.com.cn.

I'm confused. You have a pivot cell with no columns? Columns are implicit in
the pivot table, so are rows.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

Alvin, could you please look at this?

How to get a cell value without columns in a pivottable?
I know the totals object, and I use the
pivottable.activedata.cells(rowmember,columnmember).aggregates(n).text to
retrieve the cell value.

But, when there is no columns in table, what I need to do?
Please help this, really drive me mad.

Thank you.

 

[Alvin Bruney [ASP.NET MVP]]

its on www.lulu.com/owc

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

Yes, I have a pivot table without columns, just drop nothing into the
columns
field(keepping it empty), and drag some measures into the data field, you
will see the situation.

But, I have found the answer allready. there is a dummy member in the
columnaxis property, "ColumnAxis.Member", I could send it as the
columnmember
parameter of the cells() method, and it works.

Thank you anyway.
I want to buy the blackbook, but, I can't find it. I am in China, and I
couldnot found it on the www.amazon.com.cn.

I'm confused. You have a pivot cell with no columns? Columns are implicit
in
the pivot table, so are rows.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

Alvin, could you please look at this?

How to get a cell value without columns in a pivottable?
I know the totals object, and I use the
pivottable.activedata.cells(rowmember,columnmember).aggregates(n).text
to
retrieve the cell value.

But, when there is no columns in table, what I need to do?
Please help this, really drive me mad.

Thank you.