Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.
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....
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
Thanks very much, that worked....