Filter the columns of table based on click on another table row

[Vaish123]

Hello, I have one table and a bar chart. I need to filter the columns of the bar chart depending on the table row value. suppose row-1 shows the value which is sum of V1+V2+V3. when I click on the row1, bar chart will show column V1,V2,V3 data. suppose row2 value is V5, when I click row 2, the bar chart should display col V5 data only.
could anyone help with this field filtering?
Thanks,
Vaishnavi.

[ErikG]

Welcome @Vaish123
do i get it right you want to show

• for row-1 three column
• for row-2 one column

How is you table look like?

BR

[Vaish123]

please refer to the above dia, value 18 is the sum of values of(RL014+RL021+RL022). and the value 8 in another table as the value of RL016. if I click on 18 then bar chart should display only RL014, RL021, Rl022 and if I click on 8 then bar chart should display only RL016 data.

Thanks.

[ErikG]

Are these two different measures?

[Vaish123]

yes, these are different tables. I have hidden the header and just shown the value as per the customer’s UI list. I have got solution about data filtering but I want field filtering (show & hide fields) based on action.

[ErikG]

So you mean like this:

Cost selected:

Quantity selected:

If so you can use a parameter (pMeasure) and a calculated field (MeasureToDisplay) which you add as measure into the bar chart.

With a action you can than select one table and handover the parameter to switch the measure.