Lets Say Table A , Table B has the following definition and Data.
Table B ( Data Island)
and set analysis expression is as following:
However on non filter mode the expression is calculating a value against '-Consolidate-'.
Why is this happening, if possible correct the expression.
The '-Consolidate-' is a user choice to see sales of countries together or individual.