How to get drill dimension field in Variable in Reference line expression

[Rajkumar]

Hi all,

I  have a drill down country -> City -> Store in scatter plot . And i am counting the dimension field value in variable in reference line expression For example:  count (drilldown) . I am having challenge in variable, In drill down dimension  if the value is one,  it will automatically drill into next level . So it is  hard to get the exact dimension in variable .

Please help me on this.

[lorenzoconforti]

I'm not 100% clear on the requirement. Can you post a qvf file with an example of the issue?

[Channa]

try with dimentionality()

[Rajkumar]

I hope you may understand by this example

Drill Dimension :

Country ->City -> Store

My formula in Reference Line :

Sum(Sales)/ count (distinct drill down dimension)

@sunny_talwar 

[Rajkumar]

Hi,

Sorry, I just checked Dimensionality() function not working inside the reference line.

[sunny_talwar]

DISTINCT Count of your dimension will always give 1, isn't it? Can you elaborate with an example on what exactly are you trying to get?