conditional column on the basis of drilldown

[#1]

i have one straight table, in which one column is dril down group.

currently i have 3 columns name,gross,net,allowances.

Name is drilldown group upto 3 levels- say manager,teal lead,employee

Now i want to show 5th column as month when i drii down upto 3rd level as employee.

meaning when i select 3rd level-employee month column should be added in column

before-

Name(manager/teamlead)  gross  net  allowances

when I drill down to level emplyee,table will show month column

Name(employee)  month gross net allowances

I tried using getcurrentselection(), but gives me whole hierarchy when go to 3rd level like (manaer:(manager name:) |Teal Lead: (Team lead name) | employee:(employee name))
how can i check that i have selected employee now ???

[jonathandienst]

Hi

What about:

     GetSelectedCount(employee) = 1

for the condition?

HTH

Jonathan

[#3]

Its drilldown group dimension

[mahesh_agrawal · Accepted solution]

Hi,

You have to use the GetCurrentFields() in the Conditional box for that column.

Please find the attached QVW(Don't Reload the doc).

[#5]

Mahesh, its correct, its working now