Set Analysis Help

[richard_chilvers]

Please could you advise me on the Set Analysis to achieve the following:

I may have selections on a range of fields, let say Field1, Field2 and Field3.

I would like to see all data, but with just the selection in Field1 (only) applied.

I understand how to achieve this by excluding selections in Field2 and Field3, but at any time, I don't know how many fields have selections.

Thanks

[MK_QSL]

SUM({<Field2=, Field3=>}Sales)

[richard_chilvers]

Thanks Manish, but I may have selections in Field4, Field5, ............ and I want to ignore them all.

So I need a set definition which is {1} - <Selection in Field1>.

[lironbaram · Accepted solution]

sum({1<Field1=p(Field1)>}Sales)

this function disregards any selection any the model , and then reapply the field1 selections

[#5]

u can use1-$ for exclude

[MK_QSL]

Set analysis - ignores filters on all fields but one