Subtotal Versions Save

A JavaScript plugin for PivotTable.js. It renders subtotals of rows and columns with the ability to expand and collapse rows and columns

v1.11.0-alpha.0

6 years ago

Following issues resolved in this release:

  • Put Row SubTotals at Bottom Instead of Top #12
  • Initial Expand/Collapse Behavior #38
  • Clicking on pivot axis labels does not expand rows/columns #47
  • Row Sub-Total DIsplay On Top Problem. #52

Following options deprecated from this release:

  • rendererOptions.collapseColsAt
  • rendererOptions.collapseRowsAt
  • rendererOptions.colSubtotalDisplay.disableAfter
  • rendererOptions.colSubtotalDisplay.disableSubtotal
  • rendererOptions.rowSubtotalDisplay.disableAfter
  • rendererOptions.rowSubtotalDisplay.disableSubtotal

Following new options are introduced in this release:

  • rendererOptions.rowSubtotalDisplay.displayOnTop (set to false to display subtotal at bottom)
  • rendererOptions.colSubtotalDisplay.collapseAt
  • rendererOptions.rowSubtotalDisplay.collapseAt
  • rendererOptions.colSubtotalDisplay.disableFrom
  • rendererOptions.rowSubtotalDisplay.disableFrom

Lots of code refactoring is done to simplify the logic. Examples updated. New tests are added.

v1.10.0

6 years ago
  • [#33] Disable subtotals under a specified level. Thanks to @KishanManali1824
  • API documentation moved to Wiki Pages

v1.9.0

7 years ago
  • Add composer.json to let PHP developers to keep track of subtotals.js on packagist.org. #36 Thanks to @fabiomontefuscolo
  • Hide Expand/Collapse arrows when subtotal display is disabled #37

v1.8.0

7 years ago

Disable subtotals on column #27. Thanks to @sroche-tec for feedback and testing the changes.

WARNING: Backward Compatibility Breaking Change.

Changed rowSubtotalDisplay and colSubtotalDisplay renderer options to support following properties:

disableSubtotal disableExpandCollapse hideOnExpand

v1.7.1

7 years ago

This release adds support to hide subtotal rows and/or subtotal columns on expand (Issue: #26). Thanks to @Dams591 for the feedback.

Following new rendererOptions added:

  • rowSubtotalDisplay
  • colSubtotalDisplay

These options can take one of the following values:

  • "Hide On Expand"
  • "Enable"
  • "Disable" (Note: Currently Not Supported)

Check this example for the code sample

v1.6.1

7 years ago

Fixed the issue of broken tests. Details at: #25

_Changes in Version 1.6.0_

  1. Adding colTotal and rowTotal class names to headers #24 - Thanks to PR by @cesartl

  2. Following new Subtotal.js specific aggregators implemented - #2 Please refer to this example.

    $.pivotUtilities.subtotal_aggregators

    "Count As Fraction Of Parent Row" "Count As Fraction Of Parent Column" "Sum As Fraction Of Parent Row" "Sum As Fraction Of Parent Column"

  3. Test cases are rewritten to test the functionality of this plugin - #1 Run tests from here

v1.6.0

7 years ago

  1. Adding colTotal and rowTotal class names to headers #24 - Thanks to PR by @cesartl

  2. Following new Subtotal.js specific aggregators implemented - #2 Please refer to this example.

    $.pivotUtilities.subtotal_aggregators

    "Count As Fraction Of Parent Row" "Count As Fraction Of Parent Column" "Sum As Fraction Of Parent Row" "Sum As Fraction Of Parent Column"

  3. Test cases are rewritten to test the functionality of this plugin - #1 Run tests from here

v1.5.0

7 years ago
  1. Callback support for table events #21. See this example
  2. Broken link in tests is fixed #23
  3. Upgraded to use latest PivotTable.js 2.7.0

v1.4.0

7 years ago
  • CSS Classes expanded and collapsed applied to labels for #20 styling collapsable labels by @zam6ak
  • Renderer Options arrowCollapsed and arrowExpanded to customize default arrow characters
  • Introduced subtotal.css (suggestions/contributions welcome. Am not a CSS expert!)
  • Examples cleanup

v1.3.5

7 years ago
  • Fixed Issue #19 Empty filter lead to js error. Thanks to @ilyaguy for the feedback.
  • Examples cleanup