Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
My main motive behind is that I wanted to hide the line chart when the
third dimension is selected.
Please share some sample data.
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
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)