Display chart's result when selecting Expression

[#1]

Hello

How could I accomplish the following:

Have a table with some indicators (expressions) their names are in first column of the table. When click on any of them, line chart at the right changes and adjustes to match such indicator's values.

In the example, green shaded indicator (ROA) is selectd and the line chart show its values. When selecting ROE, the line chart will show ROE values.

Thanks

[#2]

If you are on version 11 you can try setting up conditional expressions. have them set to be enabled based on getfieldvalue(KPI)

[#3]

Thanks Im using v10

[#4]

Even then you can create 1 expression that contains different expressions with an if statement.

if(GetFieldSelections(KPI)=MIN, sum(Min), if (GetFieldSelections(KPI)=ICV,sum(ICV)))

Another option would be to create a chart for each KPI and conditionally suppress based on the selection.

[#5]

Where should I create this expression? in the chart? in the table?

for second option, how can I implement the condition to switch between charts? depending on KPI selected