I have a table with a column of URLs in it that I am using to create a Pivot Table. When I pull this column into the Pivot Table, I would like the individual URLs to be live links, so when I click on them, it will take me to those pages in my default browser.

I've tried making a new column in the table, to convert the URLs to live links (with a formula like "=HYPERLINK(A2,A2)" ), which works in the table, but not when I pull that new column into the Pivot Table.

Can this be done in a Pivot Table? And if so, what would be the best method?