Expand/Collapse Fields

[rafaels86]

Good morning Nicolas, i'm using this tool and it is so interesting. But miss a resource of expand or collapse a cell like occurs in microsoft excel. Do you intend to develop this? Or is this already exists?
Sorry for my english.
Rafael

[nicolaskruchten]

Hi Rafael,

Thanks for the feedback! This isn't currently supported but it's a good idea. It would require subtotal support first, which I see you've already logged issue #26 for.

The right way to do this, assuming that subtotal support exists in the PivotData object, would be to modify the default table renderer.

[nagarajanchinnasamy]

@nicolaskruchten, Thanks a lot for such a useful library.

I have added the support for roll-up summary (sub-total rows) using aggregators and renderer concepts . Its available at SubTotals branch of the fork that I have made

Would like to receive your comments/feedback from friends here before I send the pull request. I plan to add collapse-and-expand feature on top of this. Thanks.

[nagarajanchinnasamy]

@nicolaskruchten , friends... I have further enhanced subtotal_renderers with both row-wise and column-wise subtotals. Also added Collapse/Expand functionality for rows. Collapse/Expand for column subtotals is under construction....

Please check Subtotals branch. and provide your feedback. Steps to use:

1. Download pivottable-Subtotals.zip
2. Extract and place pivottable and its subfolders under document root of your local webserver
3. Access the demo using url: http://localhost/pivottable/examples/subtotal.html

Sample screenshot:

[nagarajanchinnasamy]

@nicolaskruchten and friends, happy to inform you that Subtotal.js is available for download as an NPM module or Bower component.

Subtotal.js is hosted in GitHub as pivottable-subtotal-renderer

@nicolaskruchten , In setting up Subtotal.js, I have shamelessly copied the structure, style and some portions of text and code as is from Pivottable.js repository. Hope you don't mind.

Thanks again to all of you for your feedback and support 👍

[nicolaskruchten]

All right, I think we can finally consider this issue resolved! The official answer in the FAQ is now "use Subtotal.js" :)

[kalimuthu123]

i want to make the table collapse position in loading time

[james1293]

@kalimuthu123 probably create an issue in the subtotal repo. 🙂