Set Analysis question: Only consider impact of certain fields

[alexis]

Hi

At the moment I am getting the SUM of SALES for the ENTIRE dataset {1} subject to the value of a flag and some date ranges as seen below which works as expected..

= Sum({1<[SomeFlag] = {'5'}, [EndDateNo] = {'>=$(=Min(DateNo))'}, [StarDateNo] = {'<=$(=Max(DateNo))'} >} Sales)

I have a multi-select box that displays 4 fields (lets call them Field1, ... Field4) - I want to extend the above syntax to consider these selections as well - any suggestions?

Thanks in advance

Alexis

[Anonymous]

Use

Sum({$<[SomeFlag] = {'5'}, [EndDateNo] = {'>=$(=Min(DateNo))'}, [StarDateNo] = {'<=$(=Max(DateNo))'} >} Sales)

$ will itself consider the selections of fields of multibox.

[Gysbert_Wassenaar · Accepted solution]

See this document: Ignore all selections except some specific fields using Set Analysis

[alexis]

NO

$ will consider ANY selection made - I only want to consider the impact of the 4 fields mentioned 🙂

Thanks for responding

Alexis

[alexis]

Hi Gysbert

That is EXACTLY what I wanted

THANK YOU!

Alexis