Creating an empty column in a straight chart table?

[#1]

Hi,

I need to create an empty column in a straight chart table.

I tried this tip from the community:

=''

But it interferes with the set analysis, because the other columns will now display all available data regardless of their set analysis filtering.

Thanks,

Markus

[varshavig12]

I am not sure.

But you can try this.

chr(10)

[varshavig12 · Accepted solution]

In calculated dimension:

chr(10)

[#4]

Not sure of the purpose of the empty column, but have you tried adding an expression "=0"? Then change the text colour to match the background.

Good Luck,

Pravesh

[tresesco]

Try  expression like:     =Only({<Same set analysis in other expression>} '')

[#6]

The purpose is to be able to export a certain predefined Excel report, which must include an empty column. So It won't work with zeros.

[muthukumar77]

Hi,

You can use CHR(10) in expression.

[#8]

Perhaps =text(' ') ?

[varshavig12]

Calculated dimension:

Chr(10)

You can drag this column to left or right as per your requirement in excel, it will not disturb your set analysis expression.

[#10]

Yes, thank you very much! This works fine.