IBCS table templates present business data using standardized layouts and semantic formatting. Use these templates to display actual values, variances, and key performance metrics in a consistent, easy-to-read format.
T03: Table with measure rows#
In the Matrix ribbon, select Templates and select T03 from the Performance section.
Select the relative variance column, select Conditional Formatting > Quick Rule > Negative to highlight negative variances.
To invert categories such as costs , in the Data ribbon, select the rows, then select Invert .
To add an = sign, hover over a row, select the row gripper, and select Add "=" symbol .
To display positive signs at the start of each row, in the Format tab, go to Appearance > Numbers and enable Show Positive Sign .
To customize cell and row borders, select the cell or row, go to the Format ribbon, select the border icon, and select Custom .
T04: Measure rows and integrated waterfalls#
Visualize variance and relative variance values in an income statement by using the T04 template.
Variance values are automatically plotted as a vertical waterfall chart
Relative variance values are rendered as lollipop charts
In the Matrix ribbon, select Templates and select T04 from the Performance section.
Follow the customization steps outlined in the T03: Table with measure rows section.
T05: Hierarchical bars and integrated bars#
Visualize the actuals and variances in an income statement by using the T05 template.
Current and prior year actuals are plotted using solid bar charts
Variance values are automatically plotted as colored bars
Relative variance values are rendered as lollipop charts
In the Matrix ribbon, select Templates and select T05 from the Performance section.
To customize cell and row borders, select the cell or row, go to the Format ribbon, select the border icon, and select Custom .
