I have a Chart table where the first column is a cycle group (dimension). I am trying to hide/show some columns based on the option chosen in the cycle group.
I go to Presentation tab and use:
if(getcurrentfield([Product Cycle]) = 'Green')
It seems the group name is not recognized. [Product Cycle] is not recognized and shows as wrong when typing the expression.I have checked many times the spelling.
Can you help?