Merging of two rows into one if they have same dimension in pivot table

[naveen341]

HI ziadmohd1‌

I Have a pivot table with 5 dimension as shown below

If the pro# number is same i want to concate the two records.r merge two records .How can we acheive it

Expected result :

Sender	BL Num	Pro #	mlstn_bol_awb_nbr	mlstn_pro_awb_nbr	Milestone Type All	Supplier Booked w/FF	Carrier Departed Pick-up Location with Shipment	Departed Origin Port Location	Estimated to Arrive at Destination Port	Estimated Date and/or Time of Arrival at Consignee’s Location	Arrived at Destination Port	Arrival at Consignee's Location
TQI	2000000832158	82006	82006	82006		0	1	0	0	0	0	0
	2000000832159

[ziadm]

Hi Naveen

Try to move PRO# as the second dimension .. or else please send a sample qvw

[Peter_Cammaert]

In a straight table, you can convert BL_Num (the only one that has different values for the same Pro# value) into an expression using concat() and move i to second position.

In a pivot table however, I don't think this will be possible as you are using a horizontal dimension, and all expressions (even those that are actually translated dimensions) will be repeated for every single horizontal dimension value. Pivot table objects are more restricted in their layout and flexibility.