Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Can you come up with a sample app and example?
Regards,
Jagan.
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
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
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.
Rohan
The bracket at the beginning, after your if is red. Should it be removed ?
Best Regards, Bill
yup that should be removed