Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to sheet. In one sheet I have one straight table with one dimension (Customer) and 4 expression. Now i want to click on one customer A and on the Click of A, the trigger should to fire and go to sheet 2 and show the data for one A. but In both sheet Cutomer are coming from different - different tables.
Please help me ASAP.
Thanks.
Hi,
Try to make a key between the 2 different tables using the same field in both of the tables. (like CustomerID)
then when you select 1 customer in one sheet it will filter this customer in all sheets.
BR
Ariel
Done, But I am clicking on one of the expression and then the sheet 16 should be activated and that particulr field value.
Thanks for reply.
Hi,
Try like this
Document Properties -> Triggers -> Field Event Triggers -> Select Dimension -> On Select -> Add Action -> Select Layout -> Activate Sheet and give sheet ID.
Now whenever you select value in the field the given sheet is opened.
Hope this helps you.
Regards,
Jagan.
See attached using a combination of OnSelct triggers and conditional show.
-Rob