ericc44

I’m sorry to bother you but I do not know how to sum up a column in the footer. Have you ever tried?

I use first row for create pie graph but after if i can’t keep this solution because I use filtering function.
The first row is the sum of column, for example 46 ={SUM(G3:G599)}
https://prnt.sc/fxkb3i
https://prnt.sc/fxkjuu

I think that solution is to put in footer display the total data for a column.
I have tested to go into the “Custom Commands” textfield on the table’s “Edit” screen (). but all data are on the same line
https://prnt.sc/fxkz1o
I don’t understand “after removing all line breaks” ?
Syntax is it ok for datatable identification ?
according https://datatables.net/examples/advanced_init/footer_callback.html

.tablepress-id-5 {
	"footerCallback": function ( row, data, start, end, display ) {
            var api = this.api(), data;

Thanks

Sorry Tobias,
I have used =SUM(B3:Z3) but I can not keep this solution because I use filtering.

Can you help me because when i use this code, it disapear when i saving.

Screenshot https://prnt.sc/fwmigg

.tablepress-id-5 {
	"footerCallback": function ( row, data, start, end, display ) {
            var api = this.api(), data;
 
            /* Total over all pages */
            total = api
                .column( 5 )
                .data()
                .reduce( function (a, b) {
                    return intVal(a) + intVal(b);
                }, 0 );
 
 
            /* Update footer */
            $( api.column( 5 ).footer() ).html(
                '$'+pageTotal +' ( $'+ total +' total)'
            );
        }
    } );

Hi Tobias,
sorry for delay, thank you for your quicky answer.
But When I tested this solution did not work, I had to modify it to work.
I replace
#tablepress-1_wrapper
by
#tablepress-1-no-2_wrapper

Thank you very much for your knowledge.
Have a good day.
Eric

Thanks Tobias, your are the best …
Just a remark, all column-filter-widgets are modified. I have 3 pages with 3 differents table and all menu have background color modified. Is it possible to select for a sepcific .tablepress-id-1.

Screenshot: https://prnt.sc/frei5k

Sorry,
I want to differentiate the selection menus with background color.
I want to change white background color of “Métier principal” button to another background color.

Is it possible with CSS custom ?
Please
Thanks