Excluding selections from listboxes ( Ie table should change only for a particular list box)?

[#1]

Hi Friends,

I will explain problem with an example.

e.g. I have list boxes - Department (A, B, C), Name (p,q,r,s,t,u,v,w,x,y), Attendance (1,2,3,4,5,6,7,8,9)

I also have a separate table having same 3 fields

If I select Department (B) from List box, Table will display Department B, Name q,r,s,t and Attendance 2,3,4,5.

If my next selection is Name r, Table will display Department B, Name r, Attendance 3.

This is what I don't want.

I want my table to be dependant only on Department selection and not any other field.

I hope problem statement is clear.

If any doubt, plz ask.

Hoping for your favourable responses soon.

Regarsds

Mallikarjun

[swarup_malli · Accepted solution]

Hi,

You can use one variable to write all possible values and use this variable in the set analysis definition.

ex. create a variable as follows

Variable name = vSetCalc
definition = ='{$<Department=,Name=>}'

Use this variable in the expression as follows,

=SUM($(vSetCalc) Sales)

So, in the above expression the sales value will be calculated excluing the 'Department' and 'Name' selections. Include all your excluded fields in this variable definition and use the variable in the expression. In the future, when you have to add/remove the fields, update only the variable and your expressions will get changed automatically. This will ease the maintenance.

Regards

Swarup