BBM
09-30-2009, 11:00 AM
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
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