Tables

Tables present model data in dashboards and reports. You build a table from column groups placed side by side, each showing the data a different way: over time, as a budget-to-actuals variance, or across units in parallel. Tables are created only in dashboards and reports, not in the model view. Tables are read-only. You can’t type values into a table, so all data entry happens in the model. Where a column group lets you set a column title, that title labels the source the column displays. It doesn’t create an empty column to fill in.

​

Table types

A table is one or more column groups arranged left to right. Each group is one of three types, and you can mix types in a single table:

• Periods: a time series shown month over month, quarter over quarter, or year over year.
• Variance: a comparison between sources, such as budget vs. actuals, with diff columns.
• Side-by-side: entities, departments, or other units compared in parallel columns.

Place as many column groups as you need, of the same or different types, next to each other. For example:

• Monthly columns for the current year, followed by a year-total column. Two periods groups.
• Actuals month by month for the year to date, followed by actuals vs. budget for the year to date. A periods group, then a variance group.

​

See in action