How to remove Total rows in Pivot Table 2007

[Robert]

Hello,
In my OLAP Cube, I want to display side by side the Project name and the
Project Owner. But the "Total" row hides the data of the Project Owner : we
have to click all the + signs...
Is it posssible to remove this Total row in the Pivot Table ?
Thanks

 

[Paul Conroy]

Is your report in DA or SRS ?

 

[Robert]

DA or SRS ?
;-(
please explain....

Is your report in DA or SRS ?

 

[Stephen C. Sanderlin]

Data Analysis or SQL Reporting Services (or Excel / Access)

--
Stephen C. Sanderlin
Owner/Founder - EPMFAQ
http://www.epmfaq.com/
http://forums.epmfaq.com/

Principal Consultant - BT INS
http://bt.ins.com/

This electronic message, along with any information, advice, and
opinions it contains, are mine alone and are not representative of my
employer. All information is provided in "GOOD FAITH" and on an "AS IS"
basis only. I provide no presentations or warranties, express or
implied, including implied warranties of fitness for a particular
purpose, merchantability, title, and noninfringement. I strongly advise
you to extensively test any changes, workarounds, or techniques
described herein on a development system prior to implementation in a
production environment, and you are hereby notified that I bear no
responsibility whatsoever for any loss, harm, or otherwise negative
outcomes resulting from your actions, whether or not said actions were
a result of this electronic message, directly or indirectly.

 

[Paul Conroy]

Data Analysis (DA)
SQL Reporting Services (SRS)

DA or SRS ?
;-(
please explain....

 

[Robert]

Thanks a lot Stephen and Paul,

I'm using Data Analysis (DA) !
Thanks again

 

[Paul Conroy]

I don't know about removing the column, but you should be able to change the
order of the columns by editing the pivot table.

 

[Robert]

It is not a column, it's a row... a useless row ;-(

 

[Mike Mahoney]

It is not a column, it's a row... a useless row ;-(

"Paul Conroy" <[email protected]> a écrit dans le message
de917D46D2-D181-4309-A862-B3ADA20CB__BEGIN_MASK_n#[email protected]...





- Show quoted text -

Robert

In view definition expand all columns (right click on column, select
expand option), then right click and deselect subtotal option.

regards

Mike

 

[Robert]

Hello Mike !
Great ! That works !


"Mike Mahoney" <[email protected]> a écrit dans le message de (e-mail address removed)...

It is not a column, it's a row... a useless row ;-(

"Paul Conroy" <[email protected]> a écrit dans le
message
de917D46D2-D181-4309-A862-B3ADA20CB__BEGIN_MASK_n#[email protected]...





- Show quoted text -

Robert

In view definition expand all columns (right click on column, select
expand option), then right click and deselect subtotal option.

regards

Mike