Help required on Marking Hyperlink in Pivot Table dimension object.

[#1]

I know hyperlink is always put on expression. Earlier I was straight table. But user is not willing to see the repeated data. So , I moved to pivot table , but now struggling with Hyperlink on Dimension object.

Please help.

I have a table data like: 

For a particular Req Id and Legal Name , I can have one or more than one Matched Id and Matched Name (Matched Name is partially or fully matching name.). there are two requirement.

Req Id	Legal Name	Matched Id	Matched Name
101	Test1	1021	Testcorp
101	Test1	1022	Testin
101	Test1	1023	Testing
102	Test2	1056	User
103	NewName	1078	NewName Find
103	NewName	1079	NewName Exist
103	NewName	1065	Get NewName
103	NewName	1034	No NewName

1) I need to put Hyperlink on Req Id (to open some external link.).

2)  Along with this I also need to do merging kind of thing on Req ID & Legal name to avoid duplicacy. I acheived this from Pivot table but now I am not able to create hyperlink on dimension column.

The final table should be like alongwith Hyperlink on Req Id column.

Req Id	Legal Name	Matched Id	Matched Name
101	Test1	1021	Testcorp
		1022	Testin
		1023	Testing
102	Test2	1056	User
103	NewName	1078	NewName Find
		1079	NewName Exist
		1065	Get NewName
		1034	No NewName

Any suggestion .....

[Anonymous]

‌Hi

As you are showing the Matched id and Matched Name why don't you just put the link on one of these fields?

You can still show the value but also use it as a hyperlink. Otherwise there is as far as I can see no way of using the dimension as a hyperlink in a pivot table.  When you say merge, have you tried concatenating the the two field in the script [Req id]&'_'&[Legal Name] ?