If I show my data with a normal table, I have the ability to display fields as links, and use them to provide easy access to external resources linked to the data.
I'm trying to do the same for Pivot Tables, but I can't see the option to do so. The behavior seems to be that when you click on a field in a row, the pivot table is filtered by that value. Is there a way to change this behavior and display a link instead?
I don't think pivot tables can do that right now. In Metabase, the pivot cell click is already wired to drill/filter behavior, and the column-level Display as -> Link setting only applies to the regular table visualization.
If you need clickable URLs, the practical workaround is to keep that question as a normal table and set the link on the column there. If you still need the pivoted summary, I'd keep both: the pivot for the high-level view, then a linked detail table underneath for the click-through.
If your first try is to drill through from the pivot, note that the drill result can be a regular table, so you may be able to expose the link on that detail view even though the pivot itself won't render it as a link.
Could you put the question into a dashboard, then use the click actions? All the options are there, but you might need to add a custom summary to get some sensible text.