combining multiple (excel) columns into one field?

[bridgitte]

In my data source I have multiple columns with the same peoples names in each:

(Column D relates to column C, F to E, I to H)

How do I make a list of the people, so when selecting their name in a filter pane, it counts how many times their name is in each column (like my cut & past image below!):

I'm sure its very straight forward! thank you...

[mikaelsc]

create a link table? 

userlink:

load 

createdby as user,

creator as type,

case_

residend MyTable;

concatenate(userlink)

load 

endineer_by as user,

engineer              as type,

case_

residend MyTable;

etc... 

count({type={'creator '}>}distinct case_) will then give the number of created cases.

careful : only to be used with the new dimension user