Thanks a lot this works.. if I give a calculated dimension in both the tables and then the condition in sort expression of Table2 .
But is there a way to control just the sort order in the Table 2 but not the filter selections of Table 1 affecting Table 2 .
I am trying to create a variable using Concat function (=concat(distinct country, ',')in a text box and using that variable in Table 2
on click of the text box the sort on Table 2 changes .
when I try to use the revenue metric in concat function its showing an error nested aggregation not allowed
as per the business requirement the only sort should be in same in two tables and nothing should change on any filter selections
Thanks for the reply..
If you do it in the script it is better (passing the sort order from one table to the other)
1. create a field in table 1 for sorting coutries based on revenue,i.e. Flag_Cntry_Sort
2. then create a applymap table with this , fld1 = country, fld2 =Flag_Cntry_Sort
3. create a new field in table 2 using this applymap on country field. i.e Flag_Cntry_Sort2
4. use these fields for the sorting (i.e. sort by expression)