Webi - Display table based on status of other row in same table

[former_member485101]

Hi gurus,

I need to display the rows based on looking at the status of other rows...

e.g. if Test 2 exists then display only Test 2 else display test 1 for a combination of results

for a particular batch if 'Z4PRRT' exists then do not display 'Z4PRE'

if Z6RT does not exist then display 'Z6'

Scenario Test 1 Test 2 Case 1 Z4PRE Z4PRRT Case 2 Z4POST Z4PORT Case 3 Z6 Z6RT

Below is the sample starting table and expected results table..

Appreciate your valuable inputs.

~Amit

[jyothirmayee_s]

Hi,

Try this formula:

=If(Not([Inspection Type] InList("Z4PRE";"Z4POST";"Z6RT")) And [Inspection Type] InList("Z4PRRT";"Z4PORT";"Z6")) Then [Inspection Type]

Or

=If(Not([Inspection Type] InList("Z4PRE";"Z4POST";"Z6RT"))) Then [Inspection Type] InList("Z4PRRT";"Z4PORT";"Z6") and apply filter on Flag =1.

Thanks,

Jothi

[amitrathi239 · Accepted solution]

create similar variable.After that add filter on table to select value "Show"

VAR=If([Inspection Type]="Z4PRRT" ) Then "Show" ElseIf ([Inspection Type]="Z4PRE") Then "Hide" ElseIf ([Inspection Type]="Z4POST") Then "Hide" ElseIf ([Inspection Type]="Z4PORT") Then "Show" ElseIf ([Inspection Type]="Z6RT") Then "Hide" ElseIf ([Inspection Type]="Z6") Then "Show" In ([Material])

[former_member485101 · Accepted solution]

Looks promising 🙂

Let me thoroughly test this out with my query..

Thank again for quick response.

~Amit