I've made a Pivot Table that has one column called Issue Id.
I would like to add a column to this table with the following formula:
=HYPERLINK(CONCATENATE("website.com/", 'Issue Id'), 'Issue Id')
So for example if the Issue Id is Y-19, the field would display Y-19, and when you click on it, it would take you to website.com/Y-19.
I've tried this on a regular table and it works, but not on a Pivot Table. Excel thinks the formula is wrong...