One table reflecting two different inputs and outputs suggestion

[Ahoud]

I want to create a one table that can reflect different columns headers names to a specific option/row selected from other table. for example I have 1 and 0, and 1 has different columns header/names that tells us the reason why its 1 same thing goes to 0 with different reasons.

I am trying to make it in one table that takes the input of which of the cases and reflect on the different rows and columns depending on the value 1 and 0 and there reasons/columns on same table. Is that possible, I tried matrix but output is different and doesnt satisfy my need.

would appreciate your help and other suggestions as well.

here is a small explaination of what I mean: if I select 1 this is the column headers and how relevent is 1 to each of the reason:

short cicut| accident| faluty

1               |    3         |   2

if I select 0 from other table this same table should output as follow:

child abuse| harmful supstance| un suporvied parent

2                |    1                         |   3

thank you,

Ahoud

[Ahoud]

I tried the field parameter, however its not doing what I want, as I want to be able to use the list as a columns wise not rows wise from certian category, and use conditional formating for making icon for each differnt value with no summarization. Any ideas or suggestions on how I can do this?.

thanks.

[lbendlin]

You can use field Parameters for rows, for columns and even for values.

Please show an example of the expected outcome.

[lbendlin]

Read about Field Parameters.  Also read about "Personalize visual" options  for your users.