Set analysis unexpected behavior

[chrishayes]

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]

   )

[swuehl · Accepted solution]

Use the intersection operator *

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]

   )

[chrishayes]

Thank you, that worked perfectly!