How to use a link field in a pivot table?

[Anonymous]

Hi,

is it possible to use a link expression in a pivot table?

I enable the subtotals but I am not seeing the value just the name of the field and below the total word.

If I use straight table there is not any issue. The problem is that I have multiple records related to the main one, so the same code will appear like 10 instead of just one (if I use the pivot table).

Please advise.

[Gysbert_Wassenaar]

Can you post a small example that makes clear what you want? I have no idea what you mean with 'a link expression'

[Anonymous]

Sure, in the straight table you can add an expression to looks like a url and that url may open a web site.

If I used it in a straight table I get something like this:

But in a pivot table I should see only one record instead of 3 equals (I cannot use a distinct, I need to use all the records).

In the pivot table that expression will be added to each record that exists related to the Test ID, is there a way that only display one record as the Test ID?

Please let me know if you have further questions and I will try to answer them.