Text values in Pivot chart

[#1]

Hi, everybody!

I have a problem. It seems to be very simple, but i've got no solve.

I'll try to explain:

I got 2 tables - customer list and table with different contact and address text values. Key is CustomerID. I trying to make Pivot chart with dimension - CustomerName and expression - ContactInfo(contacts&address)

Customers:

CustomerID	CustomerName
1	A
2	B
3	C

Contacts:

CustomerID	ContactInfo
1	email@a.com
1	+438534593459
2	email@b.org
2	Moscow, blablabla street
3	+545458339423
2	+(968)56324564
3	ccc@wtf.net
1	Paris, champs elysee, 13

I want to make something like this (with grouping by Customer):

Customer	Contact Info
	email@a.com
	+438534593459
	Paris, champs elysee, 13
B	email@b.org
	Moscow, blablabla street
	+(968)56324564
C	+545458339423
	ccc@wtf.net

But get only this:

Customer	Contact Info
A	email@a.com
B	email@b.org
C	+545458339423

or just empty chart.

What should i do with my expression or with something else?

[Gysbert_Wassenaar · Accepted solution]

See attached example

[#3]

Could you share your qvw?  Are all those entries for contact info somehow linked to the customer in your data set?

[#4]

Great Solution! Simple! And very simple) I spend fifteen minutes to understand how did you hide expression field)))