Compare teams against assets question

[isciberras]

Hi everyone, 

I need some help, I have a table with teams and their associated assets as shown in the table below 

Team	Assets
A	books
B	books
C	books
A	Radio
B	Radio
C	Radio
D	Radio

So from the table above I can see that Team A,B,C have books however Team D does not. We can identify that a Team D exists because Team D has a radio. 

Does anyone know what syntax I can write to identify that team D does not own the asset 'books'

------

The output of the table I am trying to create would ideally look like:

Im hoping to create a table which looks like:

Assets	Team that does not have Asset
Books	D

Thanks,

Isaac

[santhiqlik · Accepted solution]

Hi,

Check the attached. I used the below expression in straight table with the Dimension as Assets.  Also, check the sample data. I added few more rows.

Trim(PurgeChar(Concat(Total Distinct Team,' '),Concat(Distinct Team)))

[isciberras]

Hi,

I cant thank you enough for your help. The result is exactly what I was hoping to achieve. 

For some reason however with my real data i'm getting a weird result which looks like the following:

Would you happen to know  why this might be happening? The real time names are names of cities  with spaces, could this be causing the issue do you thing?

Asset Type1	Teams that Do not have Assets
P2PE, item1	''''''/Ijjjjjjjjjjjj()/jjj/''
Test Equipment, Ls	'',,''''KK,jj-jjjjjjjj-jj-()Kq,-jjj,---,,-''K
Test Equipment, Operating Rods	'F'F''''F(F)'F'F
Tools	'F'F,,H''H''FHOHHOHHUHIKK,OHOHUjj-jjjjHjjjj-jj-(F)Kq,-jjjUUOHU,-O-O-O,OHU,-Ux'F'FK
Tool - Electric	'F'F,,VvvV''V''vvFIKK,(F)vvKq,v,VV,,x'F'FvK
Test Equipment, Core Id/Phasing Devices	'F'FVV''V''FI(F)qVV'F'F

Thanks,

Isaac