Title: Sum function on export CSV data. Last modified: August 30, 2016 --- # Sum function on export CSV data. * Resolved [damiend1](https://wordpress.org/support/users/damiend1/) * (@damiend1) * [10 years, 7 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/) * Hi, * Tanks for this great plugin ! I need to know if it’s possible to have an export data CSV with the sum function under all data ? Witch is the magic formula ? * Tanks in advance. Damien * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/) Viewing 15 replies - 1 through 15 (of 18 total) 1 [2](https://wordpress.org/support/topic/sum-function-on-export-csv-data/page/2/?output_format=md) [→](https://wordpress.org/support/topic/sum-function-on-export-csv-data/page/2/?output_format=md) * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years, 7 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726014) * No magic formula for that. * There is a [SumField transform](http://cfdbplugin.com/?page_id=1167), but that outputs the sum but not the data. It’s not going to give you the data with a sum row at the bottom. * Thread Starter [damiend1](https://wordpress.org/support/users/damiend1/) * (@damiend1) * [10 years, 7 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726166) * Ok tanks for your respond. Have you a solution for me with this issue… i need an export data with a bottom sum field. Other solution, custom developpment… ? * Tanks Damien * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years, 7 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726179) * Ok. I wrote a transform and added it to version 2.9.12 which I am releasing now. * See: [SummationRow](http://cfdbplugin.com/?page_id=1167) * Thread Starter [damiend1](https://wordpress.org/support/users/damiend1/) * (@damiend1) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726216) * Hi Michael, * Tanks a lot for this solution it’s work fine ! * Always for the same project a last thing I need to know if it’s possible to give a determinate place for the different “submit login” people. * Tanks a lot Damien * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726218) * You can use “tfilter” just like “filter” but “tfilter” happens before the transform( SummationRow). * Thread Starter [damiend1](https://wordpress.org/support/users/damiend1/) * (@damiend1) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726222) * Ok, for made simple, if i write : * tfilter=”Submitted Login=test0″ it’s ok “test0” display ok, but if i write tfilter =”Submitted Login=test0,test1,test2″doens’t work. Witch code put to have test0, test1,test0 in order in my Submitted Login column ? * Tanks Damien * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726225) * `Submitted Login=test0||Submitted Login=test1||Submitted Login=test2` * Thread Starter [damiend1](https://wordpress.org/support/users/damiend1/) * (@damiend1) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726226) * filter show the three differents Submitted Login, but not in the order that i want by row. it show : * test2 test0 test1 * I need to see : * test0 test1 test2 * or the order that i want… * Tanks Damien * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726228) * I am confused. I thought you were asking to filter out certain values. Now I think you are asking to order the values. * If you want to order the rows by a certain column use `torder="column-name"` * Don’t use tfilter unless you wish to limit the results to just rows that match it. * Thread Starter [damiend1](https://wordpress.org/support/users/damiend1/) * (@damiend1) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726231) * Hi, * torder=”column-name”, nothing happens… with orderby=”Submitted Login” it reorganize the column, but not like i want. * My code is : * [cfdb-table form=”form1″ show=”Submitted Login,Repas-primaire,Repas-adulte,Repas- maternelle,Potages” torder=”” trans=”SummationRow(Repas-primaire,Repas-adulte, Repas-maternelle,Potages)”] * I need to reorder the rows by login like i want in Submitted Login column. * Tanks Damien * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726232) * torderby=”Submitted Login” * Thread Starter [damiend1](https://wordpress.org/support/users/damiend1/) * (@damiend1) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726233) * i already try it but it reorganize Submit Login by first Submit Date, but not like rows that i want… i’m deseperate. * Tanks Damien * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726234) * Post the full shortcode * Thread Starter [damiend1](https://wordpress.org/support/users/damiend1/) * (@damiend1) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726235) * [cfdb-table form=”form1″ headers=”Submitted Login=écoles” show=”Submitted Login, Repas-primaire,Repas-adulte,Repas-maternelle,Potages” torderby=”Submitted Login” trans=”SummationRow(Repas-primaire,Repas-adulte,Repas-maternelle,Potages)”] * Nothing other Tanks * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/#post-6726236) * Ok, I see that is not sorting as expected. Try this: * [cfdb-table form=”form1″ headers=”Submitted Login=écoles” show=”Submitted Login, Repas-primaire,Repas-adulte,Repas-maternelle,Potages” trans=”NaturalSortByField( age)&&SummationRow(Repas-primaire,Repas-adulte,Repas-maternelle,Potages)”] * instead of tordery, I added NaturalSortByField to the transform. Viewing 15 replies - 1 through 15 (of 18 total) 1 [2](https://wordpress.org/support/topic/sum-function-on-export-csv-data/page/2/?output_format=md) [→](https://wordpress.org/support/topic/sum-function-on-export-csv-data/page/2/?output_format=md) The topic ‘Sum function on export CSV data.’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff. svg) * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/) * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq) * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/) * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/) * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/) * 18 replies * 2 participants * Last reply from: [damiend1](https://wordpress.org/support/users/damiend1/) * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/sum-function-on-export-csv-data/page/2/#post-6726239) * Status: resolved