This sample demonstrates showing hyperlink options in row headers, column headers, value cells, and summary cells in the pivot table. Also, hyperlink options can be enabled for specific headers and value cells based on the applied condition.
|
Show Hyperlink:
|
|
|
|
Event Trace: |
||
|
|
||
|
|
||
In this sample, hyperlinks are enabled in cells based on the options selected from the Show Hyperlink drop-down list. The following options are available for setting the hyperlinks: All cells : Allows to set the visibility of hyperlink to all cells. Row headers : Allows to set the visibility of hyperlink to row headers. Column headers : Allows to set the visibility of hyperlink to column headers. Value cells : Allows to set the visibility of hyperlink to value cells. Summary cells : Allows to set the visibility of hyperlink to summary cells. Condition based option : Allows to set the visibility of hyperlink to value and summary cells based on the applied condition like less than, greater than, equals, etc. Header based option : Allows to set the visibility of hyperlink to specific row/column based on the given header text.