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.