I have a bar chart and I'm trying to define a conditional palette based on the members along the x axis. The x axis is a custom member set called [ccTLD Members + World Average]. I've created another data item in the query called [Current Member Caption] with the following expression:
caption( currentMember( [ccTLD Members + World Average] ) )
I've created a variable and it's expression just refers to this data item. Then I define my conditional palette based on this variable.
When I run the report I get the following error:
CRX-API-0005 An error ocurred at or near the position '0'. The variable named '[ccTLD Market Share].[Current Member Caption]' is invalid.
Am I doing something wrong here? Can I not create a variable based on a data item?
Thanks.
Greg
You got this error because the data item that you use in the definition of the variable is not being referenced in your chart.
Try to declare in the properties of the Chart node member ( click on categories) check the data item [Current Member Caption] on the "Properties" property. (too much properties :-) )
That worked perfectly. Thanks!