Forum Discussion
List available column values according to selection
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?
2 Replies
- Idrissshatila
Super User
HEllo tuliosouzaa ,
Yes, you could filter it were value = "ZW".
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
If I do a filter with Value = ZW it will omit all values different from ZW and the result would be only A.
