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

[SunilChauhan]

presentation ->

partial sum->  Uncheck it

[#3]

Hello Sunil,

Thanks for the quick response, but as I said, I already tried all the basic settings and its of no use. Also I have suppressed the missing and zeros in expressions, but there are some null values in my dimension MONTH, which I cannot suppress as that changes my results. I think this is causing the problem. How can i ignore the null values from Month dimemsion without checking the Supress Null Values option.??

[SunilChauhan]

try out this

if(isnull(Month)=0,Month)

or

if( len(Month)>0,Month)

[#5]

None of that works in my case... tried it. The first one gets only null and the 2nd one no change

[SunilChauhan]

can u share samplee

[#7]

try changing every expression to this

sum(if(isnull(Month),0,YOURFIELD))

[danielrozental]

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

[#9]

Hi Mady,

You can do it this way,

First add this expression

Dimensionality()

It will tell you the dimension level. For every rows it will show you a level.

Say your desired row that you want to omit shows level "0".

Then in all of you expression write this

if(Dimensionality()>0, "write your expression").

Hope I understood your requuirement properly.

Bikash Debnath

[#10]

When I use Dimensionality () at the bottom of my expressions, I get all 1 and I cannot write any expression if its all 1 s including the blank column right?

Any other suggestions please?

Thanks Again,

Mady