Trigger for Different Selection of fields for different Objects on activate sheet Action

[#1]

Hi All,

Please find the below example of my requirement .

I have two objects CH01and CH02 (which are linked objects fromSheet1)

and two fields system and subsystem in Sheet2.(System is again classified into subsystems)

Now I want to apply a triggers

1) which can select field system='Fruit' for object CH01

2)select field system='Fruit' and subsystem='Orange' for CH02.

either 1) or 2)  I can achieve by using OnActivateSheet-> SelectinField

And OnLeaveSheet->ClearAll.

How to merge both the conditions for making the two objects works as required on activate sheet.

[Gysbert_Wassenaar]

Change the expressions in object CH01 so they ignore selections in the field subsystem. For example an expression sum(Amount) would be changed in sum({<subsystem=>}Amount).

[#3]

Hi Gysbert,

The objects CH01 and CH02 are linked objects from sheet2.

So I cannot change the expression in the objections.

Please let me know if there is any other way.

[Gysbert_Wassenaar]

If they are linked objects then they are the same object in two different places. You will never get one object to be in two states at once. That cat is either dead or alive, but never both. Solution: use two charts.