Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi,
Can you post a screen shot?
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
Are you getting like the below screen shot?
Instead of Calculated dimension, try to add the Group dimension using the Add Button.
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
Hi,
Try to use the
=GetCurrentField("GroupName")
or
=GetCurrentField(GroupName)
like
if(GetCurrentField("GroupName")='Dim1',Display value)
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
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