topic Re: Complicate Set Analysis in Francophones

Complicate Set Analysis

Fri, 05 Jun 2015 06:51:00 GMT

Hay all

I need to know if there is an option

to write set analissys who calaculate a result of unselected one field

but the same selected values of other selected field's.

Example is in the Attache file

Thank

Re: Complicate Set Analysis

Fri, 05 Jun 2015 07:48:34 GMT

Yes, that is possible.

The correct Set Analysis should be SUM({$<[Sales Person]=>} INCOM)

The $-sign means keep the selections made by user and by defining [Sales Person]= in the Set Analysis you say that this selection should be ignored.

Hope this helps.

Re: Complicate Set Analysis

Fri, 05 Jun 2015 08:07:19 GMT

Hay Marc,

Thank u for the suggest.

But the $ sign show me all the sales persons,

I need the unselected [sales person] for the [sales person]

but the selected value to the Year

Re: Complicate Set Analysis

Fri, 05 Jun 2015 08:16:31 GMT

Hi Lavi,

the you should use this:

SUM({$<[Sales Person]=E({$})>} Sales)

This will select only the sales persons that are in de exluded list based on the selections you made.

So the first $ sign means you use all selections. Then in Set Analysis you say that you only want the Sales Persons that are Exclude (E()) and within that you say with Set Analysis for the selections you made {$}.

Marc

Re: Complicate Set Analysis

Fri, 05 Jun 2015 08:28:26 GMT

Thank you very Much'

It's wors.

Re: Complicate Set Analysis

Fri, 05 Jun 2015 08:52:57 GMT

I mean work's,

Re: Complicate Set Analysis

Fri, 05 Jun 2015 11:25:31 GMT

Another Quastion,

If i have a Country Field,

which syntax should i have to write if i want

to compare to the same sales person's who lived in the same country.

Thak you very much for the help.

Re: Complicate Set Analysis

Fri, 05 Jun 2015 11:41:06 GMT

Hi Lavi,

Try the following:

SUM({$<[Sales Person]=, [Country]=P({$})>} Sales)

Re: Complicate Set Analysis

Fri, 05 Jun 2015 11:58:15 GMT

Tank's