I have report with a GO URL in a column.
In the pivot table, I change the column data type to HTML and it shows the value I want to see in a hyperlinkable state. This is good.
In the chart, the column is on the x-axis. It shows the raw/plain text which is a GO URL link (<a href=saw.dll?...). This is bad.
Is there a solution to showing the column value and not the GO URL link in a chart?