I understand how to use formulas to make columns that add up data in a row, but is there a way to use formulas to make a totals row that adds the numbers from all rows in one column? For example, I have a column called "Hours", and I'd like to have a row at the bottom called "Total hours" that adds up the numbers from each row above it in the "Hours" column. Is this possible?
Unfortunately something like this is not possible in this version of plugin. For 2.0 version there will be option to select to show the sum, average etc. for columns,rows and tables. For now it is not possible without some code customization.
Also, what cost customization do you mean? it'd be nice to at least get pointed in the right direction on what "code customization" must be done to do that. I'm not asking you to code it for me, but just getting a "no" is a tad dissatisfying.
Did you think on showing sum in the footer of the table? If that is the case it is possible to enable checkbox Show a total for this column in footer but column has to be Integer or Float column type. You can also take a look at this post from our documentation - Link about sum total rows feature.
I understand how to use formulas to make columns that add up data in a row, but is there a way to use formulas to make a totals row that adds the numbers from all rows in one column? For example, I have a column called "Hours", and I'd like to have a row at the bottom called "Total hours" that adds up the numbers from each row above it in the "Hours" column. Is this possible?
Hi probizservices,
Thank you for your purchase.
Unfortunately something like this is not possible in this version of plugin.
For 2.0 version there will be option to select to show the sum, average etc. for columns,rows and tables.
For now it is not possible without some code customization.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Okay. When will 2.0 be coming out?
Also, what cost customization do you mean? it'd be nice to at least get pointed in the right direction on what "code customization" must be done to do that. I'm not asking you to code it for me, but just getting a "no" is a tad dissatisfying.
Hi probizservices,
Sorry for delayed reply.
Did you think on showing sum in the footer of the table? If that is the case it is possible to enable checkbox Show a total for this column in footer but column has to be Integer or Float column type. You can also take a look at this post from our documentation - Link about sum total rows feature.