grand total orientation

J

Joe

Hi,
Does anyone know if it's possible to put the row grand total on the left,
before the measures, and/or put the column grand total on the top instead of
the bottom?

another method might be to put the subtotal above the expanded children so i
can put a group around everything.

i'm using the owc11 / owc12 pivot table.

thanks,

--Joe
 
A

Alvin Bruney [ASP.NET MVP]

I'm not sure if this can be done, have a look at the object model for the
respective axis.

--

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
 
J

Joe

Alvin,

thanks for the response.

i didn't see anything there, and have been looking for that for a while.
instead, can you tell me if i can obtain, programmatically, the grand total
at the bottom of each column? i might be able to update the column headers
with that value.

thanks,

--Joe



Alvin Bruney said:
I'm not sure if this can be done, have a look at the object model for the
respective axis.

--

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




Joe said:
Hi,
Does anyone know if it's possible to put the row grand total on the left,
before the measures, and/or put the column grand total on the top instead
of
the bottom?

another method might be to put the subtotal above the expanded children so
i
can put a group around everything.

i'm using the owc11 / owc12 pivot table.

thanks,

--Joe
 
A

Alvin Bruney [ASP.NET MVP]

Each axis contains a totals object that you can use for that purpose.

--

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




Joe said:
Alvin,

thanks for the response.

i didn't see anything there, and have been looking for that for a while.
instead, can you tell me if i can obtain, programmatically, the grand
total
at the bottom of each column? i might be able to update the column
headers
with that value.

thanks,

--Joe



Alvin Bruney said:
I'm not sure if this can be done, have a look at the object model for the
respective axis.

--

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




Joe said:
Hi,
Does anyone know if it's possible to put the row grand total on the
left,
before the measures, and/or put the column grand total on the top
instead
of
the bottom?

another method might be to put the subtotal above the expanded children
so
i
can put a group around everything.

i'm using the owc11 / owc12 pivot table.

thanks,

--Joe
 

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