Extract Excluded set

[somenathroy]

Dear All,

Consider the table below:

Plant	Conumer	Qty
X	A	10
X	B	12
X	C	14
Y	D	10
Y	A	11
Z	C	18
Z	E	20

I want to create a Straight table which will show the list of cunsumer [along with sum(Qty)] that are not linked with the selected Plant.

For example, if any user select 'X' from Plant list, the resulted table should be as below:

Plant	Conumer	sum(Qty)
Y	D	10
Z	E	20

Pls. note that this needs to be done in expression level not in script level.

Any help would be highly appreceated.

Thanks & Regards,

Somnath

[Miguel_Angel_Baeyens · Accepted solution]

Hi Somnath,

Use a set analysis with the E() function. Note that if there is no value selected, the chart will not return anything, so I'd use it together with a calculation condition. The cahrt will have Plant and Consumer as dimensions, and the following as expression:

Sum({< Plant = E(Plant), Consumer = E(Consumer) >} Qty)

The calculation condition might be

GetSelectedCount(Plant)

Hope that helps.

Miguel

EDIT: Added the exclusion of Consumer.

[orital81]

Hi Somnath

1 possible solution is adding a triger on the first table:

Setting -> Sheet Properties --> Triggers

Choose your sheet object (The first table) and add a trigger on activate.

The action name will be select excluded and choose the field Plant.

This should do the work.

[somenathroy]

Many Thanks all of you for your reply.