Set Analysis - Disregard some selections, Accept Others

[zagzebski]

Hope this is simple.

I need to have an expression that disregards all selections EXCEPT for the following

(1) Product = 'Books'

(2) Year Month of Sale = respect the selection(s) that is made

Confused on how I say disregard everything except for #1 and #2

[nilesh_gangurde]

Hii,

i think you want to ignore the selections. You can ignore the selections by using the following script.

if you want the sum of Amount and that too only for Product = 'Books' then here is the syntax.

Sum({<Product ={"Books"},Field1 =,Field2=>}Amount)

And also the selection made in the Field1 and Field2 are ignored.

-Nilesh

[Gysbert_Wassenaar · Accepted solution]

Something like:

Sum({1<Product ={"Books"},[Year Month]=p([Year Month])>}Amount)

[zagzebski]

Worked perfect - thanks.