Passing drill down groups in expression

[rsdhavle]

There is straight table chart and all dimensions are drill down groups. Suppose i have to add Calculated dimension which would be applicable on all these drill down groups what would be the best approach.

[jagan]

Hi,

Can you come up with a sample app and example?

Regards,

Jagan.

[rsdhavle]

Example:

In Straight table chart, Dimensions are as follows

Drill Group1

Drill Group2

Drill Group3

Drill Group4

Now in this same dimension tab i want to add one calculated dimension and in such a way that the condition should be applicable on all of the above drill down groups

[Anonymous]

Rohan

Have you looked at using the GetCurrentField() function ?

Below copied form the Help:

getcurrentfield (GroupName)

Returns the name of the currently active field in a group.

Example

getcurrentfield( myGroup )

Best Regards,     Bill

[rsdhavle]

Hi Bill,

Thanks but its not working for me. I am using it in the below expression:

if

((div(aggr(RowNo(),GetCurrentField(MyGroup),$(Variable4))+1)=$(Variable1) ,div(aggr(RowNo(),GetCurrentField(MyGroup)),$(Variable4))+1, null())

But it does not affect chart in any way.

[Anonymous]

Rohan

The bracket at the beginning, after your if is red.  Should it be removed ?

Best Regards,     Bill

[rsdhavle]

yup that should be removed