Totals
When you need to add totals at the end of the table this plugin also has functionality for this.
Shortcode
[csvtohtml_create
source_type="guess"
path="large"
source_files="*.csv"
include_rows="1-30" //Just include the first 30 rows for demo
include_cols="1-8" //For demo
totals_cols_bottom="5-8" //Which columns to show totals for
totals_cols_bottom_empty="" //What to show when no totals are calculated
totals_cols_bottom_title="In total" //Title set for totals
totals_cols_bottom_title_col="4" //Which column to show this title
| measure | quantile | time | sex | age | ethnic | value |
|---|---|---|---|---|---|---|
| lx | 2.50% | 2017-19 | Female | 0 years | Total | 100000 |
| lx | 2.50% | 2017-19 | Female | 1 years | Total | 99543 |
| lx | 2.50% | 2017-19 | Female | 2 years | Total | 99512 |
| lx | 2.50% | 2017-19 | Female | 3 years | Total | 99490 |
| lx | 2.50% | 2017-19 | Female | 4 years | Total | 99474 |
| lx | 2.50% | 2017-19 | Female | 5 years | Total | 99462 |
| lx | 2.50% | 2017-19 | Female | 6 years | Total | 99452 |
| lx | 2.50% | 2017-19 | Female | 7 years | Total | 99443 |
| lx | 2.50% | 2017-19 | Female | 8 years | Total | 99435 |
| lx | 2.50% | 2017-19 | Female | 9 years | Total | 99427 |
| lx | 2.50% | 2017-19 | Female | 10 years | Total | 99419 |
| lx | 2.50% | 2017-19 | Female | 11 years | Total | 99410 |
| lx | 2.50% | 2017-19 | Female | 12 years | Total | 99399 |
| lx | 2.50% | 2017-19 | Female | 13 years | Total | 99387 |
| lx | 2.50% | 2017-19 | Female | 14 years | Total | 99372 |
| lx | 2.50% | 2017-19 | Female | 15 years | Total | 99354 |
| lx | 2.50% | 2017-19 | Female | 16 years | Total | 99332 |
| lx | 2.50% | 2017-19 | Female | 17 years | Total | 99306 |
| lx | 2.50% | 2017-19 | Female | 18 years | Total | 99276 |
| lx | 2.50% | 2017-19 | Female | 19 years | Total | 99243 |
| lx | 2.50% | 2017-19 | Female | 20 years | Total | 99207 |
| lx | 2.50% | 2017-19 | Female | 21 years | Total | 99169 |
| lx | 2.50% | 2017-19 | Female | 22 years | Total | 99129 |
| lx | 2.50% | 2017-19 | Female | 23 years | Total | 99089 |
| lx | 2.50% | 2017-19 | Female | 24 years | Total | 99049 |
| lx | 2.50% | 2017-19 | Female | 25 years | Total | 99009 |
| lx | 2.50% | 2017-19 | Female | 26 years | Total | 98970 |
| lx | 2.50% | 2017-19 | Female | 27 years | Total | 98931 |
| lx | 2.50% | 2017-19 | Female | 28 years | Total | 98893 |
| lx | 2.50% | 2017-19 | Female | 29 years | Total | 98854 |
| In total | 435 | 0 | 2979036 |