2 Replies Latest reply: Nov 30, 2017 8:57 AM by Christopher Hayes RSS

    Set analysis unexpected behavior

    Christopher Hayes

      I am using the below set analysis expression. My expectation is that if I select one of the Manufacturing Entities in the set, that the others will be excluded as I am using the $ identifier. However, if I select '01-01', the other two entities still display in the pivot table. Is there a way to get it to exclude the non-selected values?

       

      Sum({$

           <

             [Invoice Year-Month]={'$(v_current_year_month)'},

             [Manufacturing Entity Code] = {'01-01','01-02','01-03'},

             Division = {'01-ABC'},

             [Internal Bill To Company] = {'N'},

             [Internal Ship To Company] = {'N'},

             [Sales Person] -= {'JOHNNY APPLESEED','FRANK FURTER'}

           >

             }[Billed Amount USD]

         )