cell value without columns, driving me mad

I

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.
 
A

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
 
I

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.

Alvin Bruney said:
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 said:
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.
 
A

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
-------------------------------------------------------



Ivanchain said:
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.

Alvin Bruney said:
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 said:
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.
 

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

Top