Advanced Set Functions

Set Function	Description
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).
Conditional Format	Enables conditional styles to be used based on numeric ranges applied to numeric cells.