Set Analysis to ACCEPT ONLY some Values

[cristian_av]

Hi

I have the following SET ANALYSIS in a Chart:

=Sum({$ <Razon_Social_Corregida=, Rut_Empresa_Corregido=> }CantidadServicios)

As you can see, this set to "Not Selected" the fields Razon_Social_Corregida y Rut_Empresa_Corregido

I need that my expression could ONLY be modified by Field1, and Field2. i.e. It is the opposite to what I actually have.

Is it possible??

I ask this because there are about 30 fields that I don't want to interfere in the expression, and if I do it in the way that I'm actually using, it will be a very long expression, that should have to change with every new field...

any Idea?

Thanks!!

[jerem1234]

Try:

=Sum({1<Razon_Social_Corregida=p(Razon_Social_Corregida), Rut_Empresa_Corregido=p(Rut_Empresa_Corregido)> }CantidadServicios)

Hope this helps!

[cristian_av · Accepted solution]

Solved!!

This works like a charm!

({$<[$(=Concat({1<$Field-={'Field1','Field2'}>}distinct $Field,']=,[')&']=')>} Amount)

Ignore all selections except some specific fields using Set Analysis