orb
Pivot table javascript library.
Website: orbjs.net
Latest version: 1.0.9 (Release notes)
cdnjs: https://cdnjs.com/libraries/orb
Demo:
Features
Interactivity
- Drag'n'drop to move fields
- Click to sort
- Visual filters
- Drill down (cell double click)
- Multiple data fields support
- Grand totals & Sub totals
- Sub totals expand/collapse
- Enhanced scrolling (fixed headers)
- Export to Excel
(new in 1.0.9)
- Fast rendering using React
Customization
- Via code and/or toolbar
- Data headers location
- Grand totals visibility
- Sub totals visibility & collapsed state
- Data cells aggregate & format functions
- Theming: built-in & Bootstrap
Data query
Query aggregation results with a simple API:
var orb = ;var pgrid = config; // queryvar q = pgrid ;
1 field
q 118517
List of fields
q Amount: 118517 Q: 44
Aggregation func
builtin
q; Amount: 137758 Q: 39
custom
q; Amount: 7 Q: 7