13 Replies Latest reply: Oct 1, 2013 8:52 AM by Michael Solomovich RSS

    Using the 1 in set analysis but allowing certain selections

      Hello everybody,

       

      Does any know a way in set analysis that allows you to use the 1 identifier, but also allow user selections?

       

      I want to calculate Sales over the full set where the Red flag = 1. I then want users to be able to select a region and this to be included.

       

      Something like

       

           SUM({<1{RedFlag={1},Region={$}>}Sales)

       

      So when a user selects a region this is included in the sum.

       

      Any ideas?