AGGR Multiple Dimensions

[jono19872002]

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

[marcus_sommer]

Maybe in this simple way: applying Customer as dimension and count(distinct Gender)>1 as expression.