Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to add hyperlink(open tab) on the values of the one of the column in a pivot table.
Please guide.
Hi Santhosh,
You need to use Field Event Triggers to achieve this, it's under Document Properties -> Triggers.
Attached is the sample qvw
Thanks,
Jyotsna
Hi
see the example attached
good luck!
Fernando
Hi,
This is help full, But if I use the same field in another sheet the tab change is effecting.
I want this to be applied on one sheet and if i use the same field in another sheet should be normal.
Hi Santhosh,
You need to just add "Clear Field" action to achieve this
PFA.
Thank you Fernando. I used your method in a issue I was having with a link. By any chance, do you know how to remove the underline from the hyperlink text in the field?