hide or remove text

[Anonymous]

Hi,

Does anybody know how hide or remove text from table?

Other words, I have 3 string variables;

Var1  Var 2  Var 3

A        ab      abc

B        bc      cde

C        cd      qwe

D        de      asd.

I need to show only

Var1  Var 2  Var 3

A        ab      abc

B        bc      cde

D        de      asd.

Any thoughts?

Thanks,

[Anonymous · Accepted solution]

mmm, in a straight table or table box??

mmm try this

Dimenssions= Var1 , Var2

Expressions = if(Var1<>'C',Var3)

and activate Supress Zero Values for the expression

[Anonymous]

Alternative, use dimension:
=aggr(if(Var1<>'C', Var1),Var1)
Use label Var1, and check "suppress if value is null

[Anonymous]

Hi guys,

I tryed to use your ideas, but they didn't work

I need to show like a table, where I can hide some varaibles.

My key variable is Var 2. But Order should be Var 1, Var 2 and Var 3.

Thanks,

[#5]

var2 is a dimension or an expression?

you want to hide everything that starts with 'c'?

[Anonymous]

Hi Federico,

I found out issue.

Dimenssions= Var1 , Var2

Expressions if(Var1<>'C' and Var1<>'A' , Var3)

Thanks,