topic Re: Set analysis unexpected behavior in App Development

Set analysis unexpected behavior

chrishayes — Wed, 29 Nov 2017 22:00:14 GMT

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]

)

Re: Set analysis unexpected behavior

swuehl — Wed, 29 Nov 2017 22:14:22 GMT

Use the intersection operator *