Extra Information alongside Pivot Table

[BBM]

Hi All!

I have a simple pivot table and I would also like to associate a hyperlink with each row which links to a report - for example, in the column immediately to the right of the pivot table, there would be a series of hyperlinks:

Expanded:

-<Sum Of Group 1> link to group level report 1
<Group Detail 1.1> link to detail level report 1.1
<Group Detail 1.2> link to detail level report 1.2
<Group Detail 1.3> link to detail level report 1.3
<Group Detail 1.4> link to detail level report 1.4
<Group Detail 1.5> link to detail level report 1.5
+<Sum Of Group 2> link to group level report 2
+<Sum Of Group 2> link to group level report 3

Collapsed:

+<Sum Of Group 1> link to group level report 1
+<Sum Of Group 2> link to group level report 2
+<Sum Of Group 2> link to group level report 3


Can anyone suggest a way to do this?
I hope it makes sense - Im pretty new to pivot tables!

Thanks,
BBM