Overview

This page demonstrates how to use the Table Plus macro, which is part of the Advanced Tables for Confluence app, to auto-number rows and auto-total numeric columns using the following table:

Macro browser input

Select this macro

Macro Name	Advanced Tables - Table Plus
Macro Syntax	{table-plus}

Parameters/values

Column settings > Formatting > Column type (1 2 3)	S E I
Column settings > Formatting > > Column attributes (1 2 3)	style="text-align:center;" style="text-align:center;" style="background:lightyellow;text-align:right;"
Column settings > Numbering & Totaling > Insert auto number column	On
Column settings > Numbering & Totaling > Auto total numeric columns	On
Column settings > Sorting > Automatically sort in descending order	On
Column settings > Sorting > Automatically sort by this column	3
Row formatting > Advanced settings > Highlight color	lightgoldenrodyellow

Screenshot

Wiki markup input

{table-plus:autoNumber=true|autoTotal=true|sortDescending=true|sortColumn=3|columnTypes=S,E,I|columnAttributes=style="text-align:center;",style="text-align:center;",style="background:lightyellow;text-align:right;"|highlightColor=lightgoldenrodyellow}
|| Product || On Plan || Revenue ||
| A | (/) | 325100 |
| D | (/) | 315850 |
| C | (x) | 250420 |
| B | (/) | 98650  |
| E | (x) | 79010  |
{table-plus}

Example result

Note that columns are centered, rows are auto-numbered, and the Revenue column is auto-totalled. You can click a column heading to sort by that column.

Other examples

Visit our full list of product examples for additional inspiration!

Auto-number rows and auto-total numeric columns - 8.x