Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
)
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]
)
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]
)
Thank you, that worked perfectly!