I am using a drill down group with 5 drill downs.
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?
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.
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....
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).
Thanks very much, that worked....
Retrieving data ...