Pivot column total?

Hey guys - you’ve got a footer total, but one thing I really need is a column total - is this possible and I just missed it? Cheers!

Also - I’d like the data to be collapsed by default or is there an event to trigger expand/collapse?

Unfortunately there is no total for the header similar for the total in the footer.

You may call
pivot.grid.collapseAll()
to collapse all the data. Just make sure to do it after the data was completely loaded.