Requitrement on If condition

[#1]

Hi

i have field name called Quarter  in that we have field values  Q1,Q2,Q3,Q4, so

1) i have to display only Q1 for Object1(Straight Table1)

2) i have to display only Q12for Object2(Straight Table2)

3) i have to display only Q3 for Object3(Straight Table3)

Note:

i need to filter the data depends on Field Value i.e Q1,Q2,Q3,Q4 etc

Thanks,

[sunny_talwar]

May be like this

1) Straight table 1's expressions

{<Quarter = {'Q1'}>}

2) Straight table 1's expressions

{<Quarter = {'Q2'}>}

3) Straight table 1's expressions

{<Quarter = {'Q3'}>}

[sunny_talwar · Accepted solution]

Alternatively you can also use calculated dimension if you are using Quarter as one of your dimension:

1) Straight table 1's dimension

If(Quarter = 'Q1', Quarter)

2) Straight table 1's expressions

If(Quarter = 'Q2', Quarter)

3) Straight table 1's expressions

If(Quarter = 'Q3', Quarter)

And then check 'Suppress When Value Is Null' on the dimension tab