List available column values according to selection

[tuliosouzaa]

Hello everyone!

I have a table that looks like this:

Part	Shape	Value
Part 1	A	ZW
Part 1	B	90
Part 1	C	10
Part 1	D	5
Part 2	A	ZW
Part 2	W	12
Part 2	H	15
Part 2	L	20
Part 3	A	NE
Part 3	X	20
Part 3	Y	13

In another table, I want to list all possible 'Shape' values available when 'Value' == 'ZW'. So the result table would look like so:

Shape

B

C

D

W

H

L

Is something like this even possible?

[Idrissshatila]

HEllo @tuliosouzaa ,

Yes, you could filter it were value =  "ZW".

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[tuliosouzaa]

If I do a filter with Value = ZW it will omit all values different from ZW and the result would be only A.