I"d also like to be able to analyse the Sales by the Attributes in Customer, but I can't seem to do this as the Customer Attributes have no sales, and the Sales have no Customer Attributes - even though they are using the same CustomerID.
I can't seem to get Tableau to use the CustomerID to lookup the data where it does exist.
I have found a partial answer on another thread. By using the following formula (changing field names as appropriate of course):
IF ISNULL(LOOKUP(ATTR([Branch]),-1)) THEN ATTR([Branch])
ELSEIF ATTR([Branch]) = LOOKUP(ATTR([Branch]),-1) THEN ATTR([Branch]) ELSE LOOKUP(ATTR([Branch]),-1)
This has resolved the issue I had in the first part of my question, so that I now get a single, merged row:
I"m not sure U fully understand exactly why this works, but anyway, it seems to!
But this still leaves me short of being able to analyse by these attributes (the point I raised in my first reply above), as, if I'm not displaying a structured table in the way shown above, the formula can't 'do it's thing'.
So still on the lookout for any help.