Difference between revisions of "Template Tables"

Line 23: Line 23:
 
| [[Image:IBCSTable3.png|350px|centre]] || [[Image:IBCSTable4.png|350px|centre]]
 
| [[Image:IBCSTable3.png|350px|centre]] || [[Image:IBCSTable4.png|350px|centre]]
 
|-
 
|-
| Year butterfly ||
+
| IBCS Table 3 || IBCS Table 4
 
|-
 
|-
| Example ||
+
| Example || Example
 
|-
 
|-
| [[Image:ButterflyTable.png|350px|centre]] ||
+
| [[Image:IBCSTable3.png|350px|centre]] || [[Image:IBCSTable4.png|350px|centre]]
 
|}
 
|}
  
Line 33: Line 33:
  
 
== conditional formatting ==
 
== conditional formatting ==
 +
 +
==driving from ranges==
 +
 +
==csutom slices==
 +
===% to all===
 +
===% to parent===

Revision as of 11:11, 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
IBCS Table 3 IBCS Table 4
Example Example
IBCSTable3.png
IBCSTable4.png

Mark's splitting by extra column

conditional formatting

driving from ranges

csutom slices

% to all

% to parent