How can the Quarters be collapsed to a single column instead of showing three months?
Also how can the Year (2014) be made collapsible to a single column. I need to aggregate values on column collapse so that when I collapse a quarter, it shows values corresponding to that quarter(Sum of 3 months) and when I collapse an year, it shows values corresponding to that year(Sum of all quarters).
There is no way to implement such functionality through existing API, it can be done through combination of events and custom collapse handler though.
It possible to redefine collapse handler that is will be possible to assign column to multiple batches at once, so it will be possible to collapse all month to single column while clicking on the quarter icon
After collapsing|expanding the column it possible to redefine template for the first column, so it will show the value for one month or sum for all month in current quarter or year
If you need the functional sample, please open a support ticket.
Unfortunately it can’t be done with simple API call or few lines of code.
showBatch API allows to show any group of columns, so the custom code need to take some info from columns configuration and based on it build the list of columns that need to be shown or hidden.