This content has been marked as final. Show 2 replies
For pivot tables you will have to use this method in order to be able to drill down to the detail page:
On you Report-
Define Criteria: Add the Account ID (Record ID field is a must)
- Click on the Properties icon on this column--> Data Format Tab --> uncheck Override Default Data Format and select Plain Text from the Treat Text as drop down.
Add the below code in the text area.
Add this column on the Rows section of the pivot table.
Hope this helps!
Thanks! Works a treat