Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .....
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] ?