Hi
I am trying to find a way of analysing data to show where there are multiple dimensions recorded accross different records relative to on another dimension
eg as a simplified example, from the data below i want a table that filters on Customer B, as across different records they have in this case different Genders so i want to be able to identify these to check
| OrderID |
Customer |
Gender |
| 101 |
A |
M |
| 102 |
A |
M |
| 103 |
B |
M |
| 104 |
B |
F |
