Re: To Apply formula in Pivot column
Ok. How in this case I can take out the request No from the Piviot row label, and add in as a last column in the pivot
"Request No" and apply following formula to retrieve the data along with the hyperlink.
=HYPERLINK(CONCATENATE("[URL="http://cormel-itg01:8080/itg/web/knta/crt/RequestDetail.jsp?REQUEST_ID=",VLOOKUP(F9,'Issue"]http://cormel-itg01:8080/itg/w…estDetail.jsp?REQUEST_ID=",VLOOKUP(F9,'Issue[/URL] Query Risk'!F:N,9,FALSE)),VLOOKUP(F9,'Issue Query Risk'!F:N,9,FALSE))
Hence to summarize ,can we automate below,
to traverse through all the pivots of all the sheets in the workbook and add the additional column at the end of the pivot with the above formula.
For each pivot in the workbook,
Add Request No as the last column
Apply formula =as mentioned above,