Conditional Show Expression

[hopkinsc]

I am using a drill down group with 5 drill downs.

Dept Name

Cat Name

SubCat Name

Product

Customer

I have added another dimension 'EAN', I only want to show the EAN column when the user has drilled down to PRODUCT.

Does anyone know what expression i should write for this?

[#2]

Are you using Bar chart or straight table?

In straight table there is an option to show/hide the columns. There you can give the condition "getcurrentfield(group)=PRODUCT" to show/hide your second dimension.

[hopkinsc]

Hi Shans_bala,

Thanks for your reply, i am using a straight table. I have tried your expression, I am guessing that the GROUP part should be the name of my drill down group?

so i have tried... getcurrentfield(DeptToCustomer)=Product

but it doesn't work....

[#4 · Accepted solution]

I think it's getCurrentField(DeptToCustomer) = 'Product' beetween quotes (because GetCurrentField returns a string containing the field name).

You can check adding an expression containing just "getCurrentField(DeptToCustomer)" (without quotes, obviously).

Bye

[hopkinsc]

Thanks very much, that worked....