How to create this chart?

Fri, 03 Aug 2012 12:47:11 GMT

Hello All,

I have four three items of data:

ID,

PersonName,

Date,

Location

I would like to create a chart that has the date accross the top, the location down the left, and the persons name(s) in the middle combined.

The dates should be distinct, so for example the 1/3/2012 should only appear once and the names will be combined into one field.

Having difficulties doing this. Have tried to use a straight table and pivot table but have no luck. Names seem to be missing even though selected.

I would like to have what is shown in the attached excel file. Sample data also attached on second tab.

Thanks for any help that you could provide...

Regards,

Jim

Re: How to create this chart?

MayilVahanan — Fri, 03 Aug 2012 13:06:57 GMT

Use pivot table, Use Location and Date as dimension ..

And Use Concat(Distinct PersonName, ',') as Expression

Hope it helps

Mon, 06 Aug 2012 08:30:59 GMT

Thank you Mayil,

This worked just fine.

Regards,

Jim