select a value in a field based on other selection

[surajap123]

Hi All,

I have below dataset and i want to create action where when user select on system-IBM, the action should select on Type-First automatically. So everytime a user select on IBM, the Type- First should be selected in the dashboard and when click on clear, the dashboard should be cleared.

Data:

LOAD * INLINE [

    System, Product, Sales, Type

    Oracle, pen, 33, none

    SAP, pencil, 356, none

    IBM, rubber, 345, First

    Microsoft, paper, 334, none

    IBM, clothes, 433, Second

    SAP, pencil, 333, none

    Microsoft, paper, 334, none

];

Please help!

[trdandamudi · Accepted solution]

Please see the attachment:

[surajap123]

Thank you so much!!