Autonumbering Rows and Auto-totalling Numeric Columns

On this page

Overview

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

Macro Browser Input

Select this Macro

Macro NameTable Plus
Macro Syntax{table-plus}

Define these Parameters/Values

Auto number on each rowselected
Auto total rowselected
Sort descendingselected
Auto sort column3
Column typesS,E,I
Column attributes

style="text-align:center;",style="text-align:center;",style="background:lightyellow;text-align:right;"

Highlight colorlightgoldenrodyellow

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

(info) Note that columns are centered, rows are autonumbered, 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!