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

[maksim_senin]

Hi,

It's hard to understand your purposes, but at the first glance I'd suggest to use conditionally displayed dimension instead. That definitely guarantees presence drill-down/through arrows.

Best regards,

Maxim

[settu_periasamy]

Hi,

Can you post a screen shot?

[fkeuroglian]

Hi

The arrow in group dimension, only appears if your group is drill down(Hirechachy)

you have to create this kind of group

Go to the properties of the group and check if it is a drill down group or ciclyc group

[settu_periasamy]

Are you getting like the below screen shot?

Instead of Calculated dimension, try to add the Group dimension using the Add Button.

[#6]

Hi Settu,

Yes Settu i got that error. I cant use add because I need to use calculated dimension. I'm using If condition to show the dimension. Do you have any idea ?

Thanks

[settu_periasamy]

Hi,

Try to  use the

=GetCurrentField("GroupName")

or

=GetCurrentField(GroupName)

[settu_periasamy]

like

if(GetCurrentField("GroupName")='Dim1',Display value)

[#9]

Hi Settu,

i mean i want to use this expression in calculated dimension (straight table)

=if(fieldname<>'ABC' and fieldname<>'DEF', Ar_Br)

Ar_Br is my group dimension i've created contain two field (Area and Brand)

Thanks

[maksim_senin]

Hi,

This means it's better to add the expression to calc. condition of Ar_Br dimension and not to deal with calc. dimension at all.

Best regards,

Maxim