0 Replies Latest reply: Aug 14, 2017 4:31 PM by Kranthi Kumar Bhattu RSS

    Set Analysis: Counting wrongly

    Kranthi Kumar Bhattu

      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