Difference between revisions of "Template Tables"

(Built in templates)
Line 23: Line 23:
 
| [[Image:IBCSTable3.png|350px|centre]] || [[Image:IBCSTable4.png|350px|centre]]
 
| [[Image:IBCSTable3.png|350px|centre]] || [[Image:IBCSTable4.png|350px|centre]]
 
|-
 
|-
| IBCS Table 3 || IBCS Table 4
+
| Year butterfly ||
 
|-
 
|-
| Example || Example
+
| Example ||
 
|-
 
|-
| [[Image:IBCSTable3.png|350px|centre]] || [[Image:IBCSTable4.png|350px|centre]]
+
| [[Image:ButterflyTable.png|350px|centre]] ||
 
|}
 
|}
  

Revision as of 11:10, 30 November 2020

Template tables allow you to easily add predefined tables that have usefuly metrics and formatting built into them. These can be used directly or further customised for your specific needs.

General features

The tables can be built on top of a cube or Pivot View which allows calculations to be built into the column definitions, and for users to drill down on the row members.

Columns can be formatted with standard number styles, or be displayed as in-cell charts for simple visualisation.

IBCS formatting can be applied to indicated data categories like Actual, Plan and Forecast.

Built in templates

IBCS Table 1 IBCS Table 2
Example Example
IBCSTable1.png
IBCSTable2.png
IBCS Table 3 IBCS Table 4
Example Example
IBCSTable3.png
IBCSTable4.png
Year butterfly
Example
ButterflyTable.png

Mark's splitting by extra column

conditional formatting