Show Group Dimension in Calculated Dimension

[#1]

Hi,

I have a question, I have a group dimension named Ar_Br contains two fields, lets say area and brand. I want to show the dimension Ar_Br using calculated dimension, when I write Ar_Br in calculated dimension it returns red underline but the expression is OK. It can run perfectly, but there is no arrow for drill up the dimension. Do you know how to show the drill up arrow ?

Really appreciate your help

Thanks

[settu_periasamy]

Hi,

What if the Field name Doesn't met your criteria.

like if field name='XYZ', What do you want to show?

[#3]

Hi Max,

i have try to put if condition in expression, but it shows different value when i put if condition in the dimension (calculated dimension). Do you know why ?

Thanks

[#4]

Hi Settu,

I dont want to show the dimension if the field name doesnt meet the criteria.

Still dont get the idea

Thanks

[settu_periasamy]

Hi,

Can you try the Enable Conditional formatting

Add the Dimension as usual(No Calculated Condition) and in the Enable Conditional, put your condtion

(no need to put if condition) See the below screen shot

[maksim_senin]

Please see settu_periasamy's post, the setting name is Enable Conditional

[#7]

Hi Settu,

I've try your method but it give me different value. Really confuse about it.

do you know why ?

Thanks

[settu_periasamy]

is it possible to provide sample and expected result? 

[antoniotiman · Accepted solution]

Hi Indra,

if You have 2 fields in Your AR_BR group (area,brand)

You can create Group whit 2 distinct expressions

Add expression 1

If(Fieldname <> 'XXX' and Fieldname <> 'yyy',area)  //(label area)

Add Expression 2

If(Fieldname <> 'XXX' and Fieldname <> 'YYY',brand) //(label brand)

Regards,

Antonio

[#10]

Hi Antonio,

Wow thanks, it works and solved my problem.

Thanks