HyperLinker for pivotTable

Question

Hello Friends,

In my pivottable, I have a column named "orderNumber" looking like 161101...

As requested, we wanna put a hyperlinker behind this column so that the users can click on this column and are lead to our website.(http://...?orderNumber) 

To solve this issue, on the top of my head,  there are two possible appraoches.

#1. Create a excel MACRO in the sheet, using VB code to add a hypelinker on that specific column. IN the code, construst the http hypelinker

#2, in the powerpivot window, add one more calculated column to construct the http linker. Then this calculated column will be avaialble in fieldlList, however it is a linker value not a linker you can click and go to website wehn you park that column out in the "Row".

Any other possible wats? Please help if you have a better idea.

Thanks

---

Derek

Answer 1

Tried the 2nd one , does not work.

Tride the 1st one, when uploading the workbook to sharepoint, it is forced to remove.

Any suggestion?

---

Derek