Set Analysis Help

[#1]

I need help with  two set analysis expressions.

Set Analysis One:

The expression needs to return the Sum of Sales and Only include sales from  fields RPI(field name) equals to "Off Premise" and WEEK(field name) equal to 4.

Set Analysis Two:

The expression needs to look up the "Targets" table  and sum the Current Month Sales (field name)  and only include sales from fields RPI (field name) equal to "On Premise" and Region(field name) equal to 5.

[alexdataiq]

Maybe:

Sum({<RPI={'Off Premise'}, WEEK={4}>} Sales)

Sum({<RPI={'On Premise'}, Region={5}>} [Current Month Sales])