Column total in the footer with lable. Like total, Count. only for numeric columns.
I’m still not able to do that. You have any other solution for that
In Handsontable, we have the ColumnSummary plugin. It allows you to put summary calculations (count, sum, avg) and put the result in the cell defined by you. All details we put in a guide in our documentation: https://handsontable.com/docs/column-summary/
I think that guide will help you to implement the necessary part.
It is not working for updateSetting
here is an example how i calculate total https://jsfiddle.net/handsoncode/wxfr9ovc/
But there is a problem with apply filter if i uncheck blank from filter option total get hide. I need keep that total after filter applied . Or anything else that user can’t uncheck blank from dropdown
ColumnSummary’s calculations are not persistent. We mentioned using source data for calculations in the following discussion on GitHub: https://github.com/handsontable/handsontable/discussions/7719.
At the moment, there is no plan to change that behaviour.
I can suggest using the Formula plugin with our new HyperFormula engine. Then you can replace the ColumnSummary plugin with using formulas.
How I can use hyperformula in handostable. please provide example
Here is a direct link to the guide where we described the whole process: https://handsontable.com/docs/formula-calculation/
All necessary information you can find in our documentation.