At first, thank you for the plugin.

Then question: could you suggest how I can change default collapse behaviour?

I want to collapse all rows without describing attributes in rendererOptions { collapseRowsAt: [] }.

Hello this is a great tool... thank you so much.
Would be great if you are successful in adding an option to show Subtotal at the bottom as well.

Hope to see this happen soon.
Again, great work , thanks

I'm looking to see if it's possible to have a different aggregator on the subtotal (but only the subtotal).

You can do this in Excel by choosing "summarize values by".

An example might be "Average of Child Row" - where the subtotal would display an average of the aggregated child rows - so for example I'd use a sum aggreator (and when expanded you'd see the sum values), then an average aggreator for the subtotal which would show an average the child rows..

is this possible somehow?

Thanks,

Tom.

Can I save state on which row is expanded ?
I am using this to save config

onRefresh: function (config) {
var config_copy = JSON.parse(JSON.stringify(config));
$("#output2").text(JSON.stringify(config_copy, undefined, 2)); }

it works to save other items but it does not output which row is expanded...
is there something similar on subtotal js/renderer ?

Thanks

I have a data set with approx 14,000 rows (array of arrays), each row with 5 items.

the usage is straight forward, but if I use heatmap renderer it crashes:

$("#pivot1").pivot(data, {
    dataClass: $.pivotUtilities.SubtotalPivotData, 
    rows: ['Source', 'Order Type', 'Order Date', 'Customer & Order Description'],
    cols: ['Order Status'],
    aggregator: count()(['Order Date']),
    renderer: renderers['Table With Subtotal Heatmap'], // crashes
    //renderer: renderers['Table With Subtotal'],       // works
    rendererOptions: {
        collapseRowsAt: 'Order Date'
    }
});

Here is the error:

pivot.coffee:551 RangeError: Maximum call stack size exceeded
    at Function.ga [as find] (jquery.min.js:2)
    at r.fn.init.find (jquery.min.js:2)
    at forEachCell (pivot.coffee:898)
    at pivot.coffee:903
    at r.fn.init.$.fn.heatmap (pivot.coffee:908)
    at Object.Table With Subtotal Heatmap [as renderer] (subtotal.coffee:630)
    at r.fn.init.$.fn.pivot (pivot.coffee:549)
    at HTMLDocument.<anonymous> (report:176)
    at j (jquery.min.js:2)
    at k (jquery.min.js:2)
$.fn.pivot @ pivot.coffee:551
(anonymous) @ report:176
j @ jquery.min.js:2
k @ jquery.min.js:2

In my data source there are 2 columns. I drag them both to left panel as row fields. Say Level1 and Level2 are headers of these 2 columns.

In Level1...items are A, B, C. etc
Level 2 are details. Eg product details...

how to set the code so that for items A and D only, their Level2 product details are expanded ...
others (eg B, C) are collapsed ie Level2 is not expanded for B, C by default?

Thanks

Can we use multiple aggregator in the subtotal rederer?

Is there a way to fill subtotals with color or bold the text ?

Hi.

I'm working on auto deriving date attributes.

I've changed SubtotalPivotData.processKeys to replace attribute name to list, if derivedAttributes returns array instead of string.

But I have an issue there: first row of result set is duplicated.

Link to example: http://pivot.src.ilyaguy.me/examples/subtotal_pivotui_autodate.html
Link to source code: https://github.com/ilyaguy/pivottable-subtotal-renderer/blob/master/subtotal.coffee#L20

Could you take a look on this?

Automatically hide expand/collapse arrows when subtotal is disabled using renderer options to differentiate subtotal enable/disablement.

Suggestion from #27 (Disable subtotals on column)

When I enable subtotal.js, the sorters option in pivot doesn't work.

Do this option not exist when using subtotal.js? Or is there an equivalent?

Provide similar fix to subtotal.js tests as per the issue reported at: #597

First of all thank you for "subtotal.js". I have a question about subtotal on column.
I want to display "Totals" under the "NAK_YEM_KILO". How can i do this?

If you clear any filter, renderer lead to JS error:

pivot.coffee:551 TypeError: Cannot read property 'length' of undefined
    at processKeys (subtotal.coffee:84)
    at main (subtotal.coffee:591)
    at SubtotalRenderer (subtotal.coffee:638)
    at Object.Table With Subtotal [as renderer] (subtotal.coffee:641)
    at m.t.fn.pivot (pivot.coffee:549)
    at pivot.coffee:838

Hi. I managed to provide my own color scale to PivotTable.js with the following code:

rendererOptions: {
heatmap: {
colorScaleGenerator: function(values) {
return d3.scale.linear()
.domain([0, 50, 100, 101])
.range(["#83d0c9", "#65c3ba", "#009688", "#d9534f"])
}
}
},

However, the values in my subtotal rows are not coloured. Is the any solution for this?

Dear Sir
@nagarajanchinnasamy

I have tested your updated version of subtotal.js for displaying row subtotal in below portion of row.
Its working but now my subtotal for column is not working properly after this update.

Please check attached files as error in my case.

Waiting for positive reply.

In Issue #26 of PivotTable.js

@ahmad003 wrote:

I think you can make new aggregation function like % of Parent Row Total and % of Parent Column Total in excel (option Show Value as), that you can make subtotals output...

How can I use the Subtotal Aggregators with pivot instead of pivotUI()?

Your example only shows a pivotUI example, which has "vals" attribute which pivot() doesn't support..

Thanks,

Tom.

Clicking on pivot axis labels does not expand rows/columns

Is there a way we can put the row subtotals at the bottom of its parent row instead of at the top of its parent row. For example:
http://nagarajanchinnasamy.com/subtotal/examples/

Is there a way we can get the total number of Female Voters to appear at the bottom of the Female row instead of at the top?

As discussed in #30 . See the image.

Hey,

I'm working on a small project where showing a total for columns doesn't really make sense.
Would it be possible to disable this feature on columns (only)

Thank u
Seb

http://orbjs.net/
like orb.js multicolumn sum

Let's say I have a table with some numeric values which are possible to filter out in the top panel of Pivot Table. I also have values in subtotal rows. Is it possible to do some filtering according to those subtotals?

When multiple pivot tables are on the same page columns are expanded on all tables when expanding in one.

The reason is that setColVisibility (https://github.com/nagarajanchinnasamy/pivottable-subtotal-renderer/blob/master/subtotal.coffee#L303) is not scoped to the current table.

Add pvtRowSubtotal class to Totals column cells

When I'm using the Standard Heatmap the colorScale I declared in the options for pivotUI is used. If I'm using your Heatmap it's the standard blue-to-white-to-red color scale.

Hi Nagarajan , first of all many thanks for your great work on pivot table. I found it very useful but there is something I wish to achieve which is not yet supported currently, correct me if I am wrong. I wonder if we can set the default expand/collapse behavior in the first place. Right now when I expand a parent element, all levels of child elements will be expanded by default, making the tree unnecessarily long when one does not need to see all child elements. I would like to have this manually expanded.

Thanks.
Pang

Hallo Mr Nagarajan
let me introduce myself, my name leo from indonesia, and may i take your code for my job, so great code and i'm learn pivottabel from you and nichloas kructen github, and i want to ask how about to remove rows, column totals and freeze so export excel? may you help me step by step, so below attach the screen shoot picture. Thanks Mr Nagarajan

Gettig an error while using subtotal.js in pivot() function.
Can not read property 'prototype' as undefined.

Please provide support for this.

Hi there,

Thanks for the amazing work you've added on top of pivottable.
I really like the ability to expand/collapse this awesome.

One of the thing I'm trying to add to your extension is the ability to have multiple values/aggregator.
I was using the method described there:
nicolaskruchten/pivottable#30

Full like to fork:
https://github.com/unk1911/pivottable-multi-field-aggregator/tree/master

Here's also a fiddle that show multiple values in action
https://jsfiddle.net/dL86h8xr/

They added their own renderer which I changed a little bit to fit my needs.
But now I'm having a tough time to implement this in your renderer.

Have you ever thought of adding this features ? Any idea how I can implement it quickly ?

Thanks,
Damien

There any chance to set a title on subtotal column?

I would like to add cursor: pointer to row and column labels that are collapsible.
But classes alone do not differentiate between collapsible vs non-collapsible columns and rows.
At least not that I can see (e.g. classes pvtRowLabel and pvtAxisLabel)

Is there a way to accomplish this?

Hi, @nagarajanchinnasamy , I had a problem when using it in webpack + vue + es6. This my code:

As a module:

function init ( selector ) {
	var dataClass = $.pivotUtilities.SubtotalPivotData;
        var renderers = $.pivotUtilities.subtotal_renderers;
	$.getJSON("../data/mps.json", function ( mps ){
		$( selector ).pivotUI( mps, {
			dataClass: dataClass,
            rows: ["Gender", "Province"],
            cols: ["Party", "Age"],
            renderer: renderers,
            rendererName: "Table With Subtotal"
		})
	})
}

module.exports = {
	init
}

Use in Vue components

<script>
	import { init } from "./utils/utils.js"

	export default {
		created () {
			// init pivottable data
			init(".render-pivottable")
		}
	}
</script>

When the page is rendered， there are no icons(▶) ，i don't know what's wrong. Help!

*I closed this because i realized this was already asked

@nagarajanchinnasamy I would like to thank you for subotal.js. I do have a requirement where I need to either collapse multiple rows or just have them all collapsed by default. Currently, I am able to collapse one row, but when we expand that row, the rows inside are automatically expanded as well. I was hoping there was a way to have the user expand it manually instead of it defaulting to expanded.

Thank you,

Derrick

The ability to sort in subtotal by clicking on headers would be very useful. Some of the headers would need to be able to expand and sort concurrently. I know this wouldn't be trivial, but it would be a great feature.

First of all, very nice job on this packaging! I'm glad the framework from PivotTable.js was helpful :)

I notice that you've reused the test suite, which is great, but I would recommend upgrading the tests so that they actually run with your extended PivotData and Renderer, otherwise they are really just testing the core.

See here:
http://nagarajanchinnasamy.com/subtotal/examples/280_disable_subtotal.html

(Using google chrome browser)

Due to change in the order of aggregators in $.pivotUtilities.subtotal_aggregators

@nagarajanchinnasamy

I need to show row & column sub-total header label as shown in below attachment.
Please refere below image for clear understanding of what to implement.

Waiting for positive reply.

Hey @nagarajanchinnasamy

This time I'm trying to find the way to display subtotals columns only when collapsed. Once we expand I want to hide the subtotals column in order to see only the children. In the next example, Australia is expanded I therefore need to hide the subtotals columns (and values) highlighted in yellow.

Thanks !

how if I want to put subtotal row at bottom not at the top

When changing the renderer from one of the standard ones to 'Table with Subtotal' or any other of the subtotal renderers I get an exception.

TypeError: Cannot read property '' of undefined
    at buildValues (subtotal.coffee:262)
    at main (subtotal.coffee:600)
    at SubtotalRenderer (subtotal.coffee:622)
    at Object.Table With Subtotal [as renderer] (subtotal.coffee:625)
    at jQuery.$.fn.pivot (pivot.coffee:549)
    at pivot.coffee:852

at line 262 in subtotal.coffee:
aggregator = tree[flatRowKey][flatColKey] ? {value: (-> null), format: -> ""}
everything after the ? is getting marked red by Chrome DevTools

Not shure what went wrong there.

Great job! Nicolas just added drilldown support to his built-in table. Would you be willing to add this feature to subtotal as well? Thanks.

PivotTable does not display when rendererOptions is not used (both collapseColsAt and collapseRowsAt are not specified)

@nagarajanchinnasamy

We need to export pivot data in excel without those expand/collapse arrow & with all table border as it shown in html.

Waiting for positive reply.

Hi,

in case anyone is interested in 90 deg rotated column headers:

change createElement
from
if (textContent != null) { e.textContent = textContent; }

to
if (textContent != null) { if (elementType == 'th') { e.innerHTML = '<div>'+textContent+'</div>'; } else { e.textContent = textContent; } }

and add following styles
`
th.pvtColLabel {
text-align: center;
white-space: nowrap;
vertical-align: middle;
width: 1.5em;
}
th.pvtColLabel div {
-moz-transform: rotate(-90.0deg); /* FF3.5+ /
-o-transform: rotate(-90.0deg); / Opera 10.5 /
-webkit-transform: rotate(-90.0deg); / Saf3.1+, Chrome /
filter: progid:DXImageTransform.Microsoft.BasicImage(rotation=0.083); / IE6,IE7 /
-ms-filter: "progid:DXImageTransform.Microsoft.BasicImage(rotation=0.083)"; / IE8 */
margin: 2em -6em 2em -6em;
}

`

Is there any way to calculate subtotal column wise. For example I have generated table like following screenshot , what i want to get here is to calculate the subtotal of each rows.

Is it possible to give a label for the subtotals row?

In your example:
http://nagarajanchinnasamy.com/subtotal/examples/subtotal_pivot.html

if you expand on Gender, the top cell for Procince (subtotal) is blank.
It would be nice if it could automatically put in "Subtotal for Province"
Perhaps via config option or something....

Respected

I am looking for displaying subtotal of rows below the row.
Currently its showing above the rows but i need to show it below that particular row.

Please support.

Thanks
Kishan Kadam.