Show (filtered) column totals

[jonnojohnson]

Is it possible that the (numeric) column filter selections make it possible to show updated column totals somewhere automatically?

[TimShawver]

Do you mean like a "grand total" row at the bottom of the table? If so, then yes I could add that at some point. I probably won't be able to get to this for a few weeks though...there are other higher priority issues and I don't have much time to spend right now.

I think it's a good idea though, because it's a broadly useful feature. Thanks for the feedback :)

[jonnojohnson]

Yes exactly. Here's an example where it could be used to total up sales data based on different sales people or product lines: http://nbviewer.ipython.org/github/jonnojohnson/QGrid/blob/master/Sales%20Data.ipynb

[fterbo]

Any traction on this? This would be super useful. Alternatively if you could allow a custom "footer row" that was never used in sorting or filtering, this would be flexible enough to implement our own sums (and other metadata).

[TimShawver]

Sorry I haven't worked on it yet and I'm not sure when I'll be able to get to it. Good to know people want it though. The idea sounds really interesting. I could imagine letting people provide a "calculate_total" function for each column that takes in the list of values currently showing in the column and is responsible for returning the "total" for the column which gets shown in the footer row. At that point it's really similar to the concept of a formula cell, but I guess it's a little different since you'd want this "grand total" row to always be visible.