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!