got 2 tables here which hold the same dimension. Is it possible to link them, so that if you click on one table to sort it, the other table automatically gets sorted in the same way?
There is no way for one object to sense how another object is sorted, so you cannot do it quite the way you want.
You may be able to get close by adding a sort state variable, and sorting each table by using sort expressions that include the variable. You may need a button or text box with an action to set the values of the variable. That way when you select a specific value of the variable (by clicking on a button for example), both tables will sort in the same way.
If you need more specific or detailed help, please post a sample model so that someone can show you how to do this.
HTH
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
I have attached an example of another work around. Here I created a cyclic group with two instances of the same field, one sorted ascending and the other sorted descending. Then if I use the group instead of the field on the two charts, they both sort the same way. If you toggle the cyclic on either one, the other also changes.
To add two instances of a field to a cyclic group, first add the field in the normal way, then add an expression, and enter the field name for the expression. I suggest that you change the display text for each version, but that is optional.
HTH
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
you can have multiple instances of the same object. Copy the object > then instead of CTRL + V, right click > Paste sheet object as link. This way you'll an identical copy of your original object (in fact both will have the same ObjectID) and they will respond to the same selections,
