expression that ignores any selection apart from 3 fields

[#1]

Hi all,

i am trying to get a chart to ignore any selections made aprt from 3 fields. so if the user selects any fields apart from the 3 allowed then the charts won't change.

i am using variables as expressions.

expression 1

$(vItemCount_Listings)

expression 2

$(vTargetSum_Listings)

I want them to ignore any selections apart from the following 3

it_objective_name

territory_region

JOIN_territory

Can anyone help please?

[#2]

You should use Set Analysis this is an example:

=Sum( {$<YEAR = {2011}, COUNTRY = {USA}>} [IMP USD] )

this will give you only the sales for USA in 2011 no mater what selections you do.

Hope this Helps!!

[#3]

hi, how can i get it to include all values of the 3 fields though and exclude all values of all olther fields. ?

so in expression 1:

i want the chart to IGNORE any selections made in all fields apart from

it_objective_name

territory_region

JOIN_territory

So selects can be made in the above 3 fields (any value) and the chart is to react to them.

Thanks

[#4]

Hi,

We can do it by using set analysis. For an example, if you want to get the sum of sales amount excluding the country selection made, you can have formula mentioned below.

Sum({$<Year={$(=(vYear))},Country=>}Sales_Amount)

Hope this will help you to get the solution.

[Gysbert_Wassenaar]

sum({$<[$(=Concat({1<$Field-={'it_objective_name','territory_region','JOIN_territory'}>}distinct $Field,']=,[')&']=')>} Amount)

[#6]

Hi Gysbert,

Thanks but that didnt work. I think it's because of the SUM. if i just use sum($(vItemCount_Listings)) then i get nothing, so the expression i use is just the variable $(vItemCount_Listings).

How would i use your example but without using the SUM function?