HelpBot Assistant

How can I help you?

HyperlinkSettings

16 Mar 20262 minutes to read

Allow a set of options to display a hyperlink to link data for individual cells that are shown in the pivot table.
These options allow to enable a separate hyperlink for row headers, column headers, value cells, and summary cells in the hyperlinkSettings class.
The options available are:

  • showHyperlink: Allows to set the visibility of hyperlink in all cells.
  • showRowHeaderHyperlink: Allows to set the visibility of hyperlink in row headers.
  • showColumnHeaderHyperlink: Allows to set the visibility of hyperlink in column headers.
  • showValueCellHyperlink: Allows to set the visibility of hyperlink in value cells.
  • showSummaryCellHyperlink: Allows to set the visibility of hyperlink in summary cells.
  • headerText: Allows to set the visibility of hyperlink based on header text.
  • conditionalSettings: Allows to set the visibility of hyperlink based on specific condition.
  • cssClass: Allows to add CSS class name to the hyperlink options.

    By default, the hyperlink options are disabled for all cells in the pivot table.
    Refer to the hyper link documentation for complete configuration steps.

Properties

conditionalSettings ConditionalSettingsModel[]

Allow options for setting the visibility of hyperlink based on specific condition. The options available here are as follows:

  • measure: Allows to specify the value field caption to get visibility of hyperlink option for specific measure.
  • condition: Allows to choose the operator type such as equals, greater than, less than, etc.
  • value1: Allows to set the start value.
  • value2: Allows to set the end value. This option will be used by default when the operator Between and NotBetween is chosen to apply.

Defaults to []

cssClass string

Allows to add the CSS class name to the hyperlink options. Use this class name to apply styles to a hyperlink easily.

Defaults to ’’

headerText string

Header caption (row or column) used to set the visibility of hyperlink in the cells based on specific row or column header.

Allows to set the visibility of hyperlink in column headers that are currently shown in the pivot table.

Defaults to false

Allows to set the visibility of hyperlink in all cells that are currently shown in the pivot table.

Defaults to false

Allows to set the visibility of hyperlink in row headers that are currently shown in the pivot table.

Defaults to false

Allows to set the visibility of hyperlink in summary cells that are currently shown in the pivot table.

Defaults to false

Allows to set the visibility of hyperlink in value cells that are currently shown in the pivot table.

Defaults to false