6 Replies Latest reply: Feb 2, 2016 8:32 AM by Stefan Wühl RSS

    Set Analysis - Included and Excluded

      Hi All,

       

      Perhaps a quick one - I have a Region table i.e.

       

      [Region]

      UK

      US

      Fra

      Aus

      Global

       

      I need to sum where Region filter is equal to 'Global' - the expression must not ignore any other selections, BUT, must ignore any selection made on  Region.

       

      I have the following so far - however, this does not populate when selection on region filter is made (i.e. selection <> 'Global')

       

      Sum($<Region={'Global'}>}Sales)

       

      Please help!