Plotalot can add a totals row to Plotalot tables and Responsive tables. It can't do this for Google tables because the sort function could move the totals row into the body of the table.
Specify a list of columns to total, e.g. 1,2,3 to add totals for the first three columns. For numeric columns, the total is the sum of the row values for that column. For non-numeric columns, the total is the number of rows.
You can optionally specify the number of decimal places, decimal separator, and thousands separator. If you don't specify them they default to 0, ".", and none (prior to version 6.19 they defaulted to 0, ".", and ",").
Use semi-colons (;) to specify these, for example:
1,2,3 |
formats the totals with no decimals and no thousands separators |
1,2,3;2;.;, |
formats the totals with 2 decimal places, decimal separator ".", and thousands separator "," |
1,2,3;0;,;. |
formats the totals with no decimal places and thousands separator "." |
You can use SQL number formatting for column values that are to be totalled, provided that the decimal and thousands separators used by the SQL formatting match the separators specified for the totals. Plotalot will use the separators specified to interpret the SQL-formatted numbers. For example, if the decimal and thousands separators specified for the totals are "," and ".", Plotalot will interpret a column value "123.456,789" as the decimal number 123456.789.