Show only certain values in Straight table

[#1]

Hi,

I have a table that calculates A,B,C values in one column. I want to create 3 different tables and in those tables to show only the corresponding values like in table 1 i want to show A values, in table 2 B values and in table 3 - C values. How can i achieve it? The ABC field is an expression.

[PrashantSangle]

Hi,

If it is your dimension

then write calulated Dimension as

if(Wildmatch(fieldName='A'),FieldName)

and tick on Supress Null in Dimension tab

If it is your expression through which you are calculating A,B and C

Then Write in Expression

IF(Expression='A',Expression)

and Tick on Supress Null values in presention Tab.

Regards

[#3]

Hi,

It is expression. I have already tried F(Expression='A',Expression) and checked supress Null values but it simply doesn't supress.

[PrashantSangle]

Hi,

Basically If you have only that expression then this should work,

If you have some more expression except that expression then,

For every expression you have to write

Like

If(Expression1='A',Evalute Expression2)

Then it will give you - symbol and Then Supress Zero and Supress Missing Should work.

If still not understand the logic then provide me sample file, I will do it for you.

Regards,

[#5]

Hi,

This is my example: