Hi,
Lets Say Table A , Table B has the following definition and Data.
Table A
Country Sales
A 100
B 200
C 300
D 400
Table B ( Data Island)
Countryy
-Consolidate-
A
B
C
D
and set analysis expression is as following:
=num(Sum({$<[Country]=P([Countryy])>}Sales),'#,##0')
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.
Thanks,
Kranthi