Hiding Columns

[Anonymous]

Hi

Is it possible in a straight or pivot table to hide columns when they total zero?

Thanks

[MK_QSL]

If total = 0 why you include them in your expression or dimension?

I hope you are talking about hiding columns ...

If this is so, go to presentation tab and select Suppress Zero-Values

[#3]

Hi,

In Presentation tab, you can add a condition to show the column when it is not null or zero else hide it.

[Anonymous]

I have a table with a lot of expressions which can be zero depending on what is selected.  I just wanted to save space by hiding the column when it is zero

[Anonymous]

Can you show an example?

Thanks

[#6]

I have a straight table, where if Circuit count is zero, I want to hide that column.

Here is the conditional show applied in presentation tab.

Similar way, you can add condition for expression too.

[SunilChauhan]

see the attached file where column2 is hidden

using presention tab in chart properties

hope this helps

[MK_QSL]

You can go to presentation tab where

Show Column

Hide Column

Conditional

features available.

You can select respective column and select any one of above...

[jonathandienst]

Hi

Do you want to hide a row when all the columns sum to a total of 0?

Suppress zeroes wont work in such a case. You first need to change the expressions something like this:

Assuming n expressions in the table:

=If(RangeSum(Column(1), Column(2),....Column(n)) <> 0, <your expression1>, 0)

=If(RangeSum(Column(1), Column(2),....Column(n)) <> 0, <your expression2>, 0)

..

=If(RangeSum(Column(1), Column(2),....Column(n)) <> 0, <your expressionn>, 0)

The rangesum should include all the column numbers you want to consider for your condition.

<your expressionn> is your existing expression 1 to n

Now suppress zeroes will cause these rows to be hidden.

HTH

Jonathan

[#10 · Accepted solution]

In the expressions window, for the particular expression (let's say it is sum of Data), you can write a expression in the 'Conditional' box as..

=If(Sum(TOTAL Data)=0,0,1)