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

Tags: #<Tag:0x00007f8b1d496718>
#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 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

image
image.png783×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.

#9