Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See this document: Ignore all selections except some specific fields using Set Analysis
Use
Sum({$<[SomeFlag] = {'5'}, [EndDateNo] = {'>=$(=Min(DateNo))'}, [StarDateNo] = {'<=$(=Max(DateNo))'} >} Sales)
$ will itself consider the selections of fields of multibox.
See this document: Ignore all selections except some specific fields using Set Analysis
NO
$ will consider ANY selection made - I only want to consider the impact of the 4 fields mentioned 🙂
Thanks for responding
Alexis
Hi Gysbert
That is EXACTLY what I wanted
THANK YOU!
Alexis