Hyperlink In Pivot table

[#1]

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 .....

Message was edited by: Vineeta Dahiya

[Gysbert_Wassenaar]

Dimensions in pivot tables cannot be made hyperlinks. But it is possible to assign an Open URL action to the OnSelect field trigger of the Req Id field. You can do that on the Triggers tab of the document properties window.

[#3]

I tried the same feature but somehow the trigger is not opening.

I  select the field and assign the action to Open URL like  www.google.com , but it is not opening the URL.

Correct me if I am doing something wrong. Is there any other setting to Open a external URL. Please suggest

[#4]

Please help. It is urgently needed for one of the client's requirement.

[Anonymous]

Hi

Add an expression to your pivot table, choose "Link" as representation and add somthing like this

to your expression ='Link'&'<url>https://eu1.salesforce.com/'&OpportunityId

In the case above this will open SalesForce.com and open the opportunity in salesforce.

[#6]

But I need the dimesion to be merged and hyperlinked also. If I put it as expression, the column value will be repetative.

[Anonymous]

Yes, you will have a column containing the link text for each row. It would look something like this.

Apart from this I can't see any other way of embedding  link inside a pivot table dimension.

[#8]

Thanks Morris. I understand the concept. But the problem is Client want the representation in that manner. If I add this link as a column , this is again repeatative value. Ideally, he want this link applied in 668 , 669 referring the  example you shared.

I am looking for OnSelect and OnChange trigger in Field Event Trigger. But this seems not working as well.

[lookforward1]

Hi Morris,

I am able to get the url in the values section in pivot table but not as a hyperlink.Can you provide steps on how you achieved this per your screenshot?Also i don't see representation in values section.

Thanks!