(My apologizes if this has already been answered; searched but couldn't find a thread)

Looking to get the hyperlinks that are active in the data to be active in the pivot table. Example: cell contains... =HYPERLINK("www.bing.com","bing") ... but pivot table only returns the text, not an active link.

Is there another formula that should be used, PivotTable setting, or something else?

(Attached a sample for reference)
Test Data.xlsx