Overview

This page outlines an example of how to style the row with totals of numeric columns using the Table Plus macro, CSV (Comma Separated Values) macro, or Attachment Table macro, which are part of the Advanced Tables for Confluence app. This example assumes your data itself contains the formatting you want, such as comma separators and dollar signs. The instructions given on this page ensure that when you choose to have a row with totals of numeric columns, it too is similarly styled.

Macro browser input

Select any of the macros

Macro name	Advanced Tables - CSV Table Advanced Tables - Table Plus Advanced Tables - Attachment Table
Macro syntax (Old editor)	{csv} {table-plus} {attachment-table}
Macro syntax (New editor - case insensitive)	/Table Plus /CSV (Comma Separated Values) /Attachment Table

Define these parameters/values

Auto total numeric columns	On
Column types	s,f"0,0",f"$0,0.00"

Due to the values set in the Column types parameter, the Auto Total row also follows the same column types.
See Formatting options for numeric rows for a full list of available formatting options.

Parameters set in the macro editor

Wiki markup input (Old editor)

For a table built using the CSV (Comma Separated Values) macro:

{csv:output=wiki|autoTotal=true|columnTypes=s,f"0,0",f"$0,0.00"}
"Item","Units","Revenue"
"Kazoos","1,368","$4,074.25"
"Accordions","445","$222,500.63"
"Mandolins","2,296","$1,033,200.00"
{csv}

Example result

Other examples

Visit our full list of product examples for additional inspiration!

Advanced Tables for Confluence

How to format the Auto Total row for numeric columns - Cloud