List available column values according to selectio...

tuliosouzaa · ‎06-29-2023

Hello everyone!

I have a table that looks like this:

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 · ‎06-29-2023

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

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos

Follow me on LinkedIn

Vote for my Community Mobile App Idea

Proud to be a Super User!

tuliosouzaa · ‎07-05-2023

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

List available column values according to selection