Position of Drill Down

[Anonymous]

Good Morning Every One.

Today I am trying to get the position number of Drill Down.

For Example: In Dynamic Drill Down you can see you have 3 dimensions.

So my Question is,

When I Drill down the data twice i will be in third Dimension so i must get the result 3

=PositionNumber(Dynamic Drill Down) = 3  when I drill down the data twice

[Anonymous]

My main motive behind is that I wanted to hide the line chart when the

third dimension is selected.

[prma7799]

Please share some sample data.

[passionate]

Hi,

I have drill down of continent,Country,State and Branch:

You can add a variable and set its value to below:

=if(GetSelectedCount(Continent)>0 and GetSelectedCount(Country)=0 and GetSelectedCount(State)=0,2,

if(GetSelectedCount(Country)>0 and GetSelectedCount(State)=0,3,

if(GetSelectedCount(State)>0,4,

)))

And use this variable where ever required.

Regards,

Pankaj

[Anonymous · Accepted solution]

Thanks Everyone,

I found the Answer: GetCurrentField----------It will give you the field name from the group which ever is selected.

=if(GetCurrentField([Dynamic Drill down])= 'E_CREATED_BY_USER',1,0)