Skip to content

Advanced Set Functions

Set FunctionDescription
Hide Dimension HeadersWhen 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 ElementsRemoves 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).
Conditional FormatEnables conditional styles to be used based on numeric ranges applied to numeric cells.