I have a pivot table that shows units sold and sales $. When I click the hyperlink value for units or dollars, I get an error message saying ‘Invalid Column Name’ and it then references one of the columns in my data source - which is a Generic Inquiry.
What I’m trying to see is if I can customize where these hyperlinks link to - and create my own drilldown tab. I’ve looked around on this community and prior questions like this have either no answer or mentioned you can’t customize the hyperlinks.
Hoping things have changed since and maybe there’s a solution?
thanks all!
Joseph
