Column total in the footer with lable. Like total, Count. only for numeric columns

Getting help Questions
1

Column total in the footer with lable. Like total, Count. only for numeric columns.

2

I’m still not able to do that. You have any other solution for that

3

Hi @suman.dutta,
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.

4

It is not working for updateSetting

5

here is an example how i calculate total Handsontable example - JSFiddle - Code Playground

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

image
image783×590 30.4 KB

6

Hi @suman.dutta

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.

7

How I can use hyperformula in handostable. please provide example

8

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.