Drill Through Hyperlink any Field (Cross tab reports)
I would like any field to be a hyperlink not just metric fields. The links can only be the aggregates and not any of the other columns. One of my fields are a date field and the others are aggregates. I want the user to be able to click on the date field for one report and the aggregates for another. My report features a pivot table but I want the user to be able to click on another field so that they can drill to another report or a report that displays all the metrics. In the example, the user would click the metrics like July, August, etc and the drill through report would be based on the month. If they click on Fiscal Year the drill through report would be based on the fiscal year.
This can already be accomplished in a standard report but I'm asking that it be possible in a cross tab report.