Hide Column

[#1]

Hello,

I'd like to show the first one, which is a sum, the other three columns, and then hide the others, without removing their values from the query.

Should I write something like

If(ColumnNo()>4, #ExpressionToHide#, )

?

I've attached my example.

I'd like to show only columns 0,1,2,3.

Thanks in advance.

Michele

[#2]

I am not clear with your problem.
Can you please elaborate a bit which all columns you want to see and which not?

[#3]

Hi,

You have an option to hide column in the presentation tab of the chart properties.

Thanks

[#4]

You can apply condition in Expressions in chart property by cliking conditional check box.

Request you to brief your requirment little more clear

[#5]

Hi,

As u have taken pivot table,there is no hide option available in properties.

i have seen ur chart ..pls go through process.

Properties >Dimension>Just check "Suppress when value is null"

Hope it will help u..

[#6]

Sorry for not being clear, I'm a newbie.

I have currently this situation

I would like it to be

When I check for "ColumnNo()", they have values 0,1,2,3

Thank you.

Michele