Skip to Content
0

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

Mar 20, 2017 at 03:24 PM

32

avatar image

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

10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Mar 20, 2017 at 03:58 PM
0

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])

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Looks promising :)

Let me thoroughly test this out with my query..

Thank again for quick response.

~Amit

0