Advanced Set Functions
|Hide Dimension Headers
|When a dimension is on rows or columns this function will remove the associated title row or column. This is often used in junction with a custom header.
|Suppress Empty Elements
|Removes rows or columns (depending on set position) where the entire row or column has only zeros (for numeric cells) or blank strings (for text cells).
|Enables conditional styles to be used based on numeric ranges applied to numeric cells.