Text Hyperlink in Pivot

[zestypathak]

I am working on a project on an Excel database. My source data has a column with values hyperlinking to a different source. They work fine when in the table, but when I create a Pivot, that column with hyperlink values shows up as plain text, and when clicked on them, they don't redirect as a normal hyperlink cell should.

I have been stuck on this since last week. Please advise

 

[jdellasala]

I am working on a project on an Excel database. My source data has a column with values hyperlinking to a different source. They work fine when in the table, but when I create a Pivot, that column with hyperlink values shows up as plain text, and when clicked on them, they don't redirect as a normal hyperlink cell should.

I have been stuck on this since last week. Please advise

Sorry, not a solution, but as a rule a pivot table will only aggregate text values - typically count. However, search YouTube for a solution, I'm sure there's a couple on the subject.