Cross table / changing axis on the go depending on drop down

[Sedat Diken]

Hi,

I have been trying to find a workaround to change a specific axis based on drop-down selection, but I couldn't figure out how to crack it. I have a drop-down property control helping me to NEST some columns invertical axis.

Now only thing I need is to dynamically change the value axis based on this selection. I have three values in the drop-down property and also I have three data tables with identical columns (column name: ToT). Tables are linked to eachother through key columns.

When the first value is selected from the drop-down it should get the "ToT" column from Table 3.

When the second value is selected from the drop-down it should get the "ToT" column from Table 2.

When the third value is selected from the drop-down it should get the "ToT" column from Table 1.

I've also attached a screenshot captured from Spotfire.

Thanks,

Sedat

[Tyger Guzman 2]

Set your expression with specifying which table the element should come from.

[Sedat Diken]

Thanks @tyger0951 againfor taking the time to explain this step by step, really appreciate it. I'm going to try and let you know the outcome.