Is there a way to remove the Totals column on Pivot?

[#1]

I have a Pivot where, I have a Dimension and some expressions. At the end of the Pivot I see a blank Column with all $0    0.0%     0      £0 etc for the respective columns. I just want to get rid of this as its not proper in my Pivot. Is there a special way to get rid of it as I tried all the basic steps from chart properties.

Thanks in Advance,

Mady

[danielrozental]

Did you look at my suggestion?

Go to the dimension tab, select the "MONTH" dimension and check the flag "Suppress When Value Is Null".

[#3]

Hi,

Have you tried deselecting the partial sums box in the presentation tab?

Otherwise, you should be able to use a conditional query around dimensionality to sum only the figures you want to see. For instance:

if(dimensionality()>1 , sum(Fieldname))

Assuming the total field's dimensionality is equal to 0, this should work.

Matt