Put Row SubTotals at Bottom Instead of Top #12

j8lp · 2016-09-21T00:34:34Z

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?

nagarajanchinnasamy · 2016-09-28T11:10:15Z

Hi, Currently its not possible to put the subtotals as the last row of the parent. I will take this as an enhancement request and if it doesn't impact the performance, I will try to implement it. If implemented, I will make it configurable through an option.

Thanks for the feedback.

Dams591 · 2016-12-28T14:52:35Z

Hey @nagarajanchinnasamy
Any progress on this ? any idea how I could do that easily ? Been trying for quite a long time and I have to say I'm struggling. Also any idea how to not display subtotals when expanding ?
Thanks.
Damien.

Dams591 · 2016-12-28T14:57:25Z

To me the secret is inside buildRowHeaders, but can't modify it easily.

nagarajanchinnasamy · 2017-01-31T13:25:26Z

Hiding subtotals when expanding is addressed in #26

nagarajanchinnasamy · 2017-01-31T13:30:30Z

@j8lp @Dams591 When I started writing this plugin, unknowingly :( I have made a strong assumption that the subtotal row goes on top. This will need major refactoring of the code.

I will keep this in my TODO list definitely. But will need more time.

nagarajanchinnasamy · 2017-02-02T12:00:15Z

As @Dams591 put it rightly, the secret is in buildRowHeaders. But it shouldn't be that difficult :)

One of you want to give it a try? Otherwise, i will come to this after completing work on "Hide On Expand" feature.

Dams591 · 2017-02-02T12:03:42Z

I'm still integrating the hide on expand into my solution, since I have the multiple values on and some other things I'm having a tough time but I'm getting there. Once I have it I'll give it a try. Let me come back to you in 2-3 days.

nagarajanchinnasamy · 2017-02-02T15:19:12Z

I guess, we just need to alter the way recursion is done. No other changes may be needed.... hopefully :)

nagarajanchinnasamy · 2017-02-02T23:35:25Z

Just played around changing the method of recursion. It does not help. It is tough!!!

nagarajanchinnasamy · 2017-02-04T08:34:06Z

Points to remember are:

Current logic makes use of row-span, which is always upper-row-to-lower-row expansion in HTML
Expand and Collapse operations affect the parent header's row-span values

So, the secret is in buildRowHeaders, collapseRow and expandRow functions :)

Kishan1824 · 2017-05-08T05:56:40Z

Repsected

I just tried to modified buildRowHeaders function to bind subtotal below the row, but nothing happened.
So please try on that to resolve this issue.

Thanks

Kishan1824 · 2017-06-06T10:22:47Z

Respected

Is there any way to display sub-total below the row.
If possible then please suggest.

Waiting for positive reply.

Thanks

Dams591 · 2017-08-14T14:57:12Z

Hey @nagarajanchinnasamy
Did you have the time to work on this ? Still can't figure it out :(

nagarajanchinnasamy · 2017-09-17T12:41:11Z

Sorry for the delayed response. I am working on it. Scheduled for release v1.11.0.. May take couple of more weeks minimum.

hkbeer · 2017-09-20T05:49:41Z

Yes please create this Subtotal at the bottom option. It is very important. Thanks

nagarajanchinnasamy · 2017-09-30T16:08:17Z

Column Collapsing, Row collapsing and showing row subtotals at the bottom implemented. Please check latest v1-11.0 branch. Pending: Row expansion when displaying subtotals at the bottom.

Am using examples/210_collapse_rowscols.html to test and debug.

Kishan1824 · 2017-10-04T06:50:04Z

Dear Sir 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.

…

On Sat, Sep 30, 2017 at 9:38 PM, Nagarajan Chinnasamy < ***@***.***> wrote: Column Collapsing, Row collapsing and showing row subtotals at the bottom implemented. Please check latest v1-11.0 branch <https://github.com/nagarajanchinnasamy/pivottable-subtotal-renderer/tree/v1-11.0>. *Pending*: Row expansion when displaying subtotals at the bottom. Am using examples/210_collapse_rowscols.html <https://github.com/nagarajanchinnasamy/pivottable-subtotal-renderer/blob/v1-11.0/examples/210_collapse_rowscols.html> to test and debug. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#12 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AS5TBPYPSOWvxOVe9LJg6CrcToI_D1f2ks5snmdygaJpZM4KCSPG> .

nagarajanchinnasamy · 2017-11-26T11:37:32Z

@KishanManali1824 and friends,

Please check the latest version at v1-11.0 branch. I will merge this branch into master after your confirmation.

Thanks :)

Kishan1824 · 2017-11-27T04:45:32Z

Respected Let me check it. Reply you back. Thanks for updation.

…

On Nov 26, 2017 5:07 PM, "Nagarajan Chinnasamy" ***@***.***> wrote: @KishanManali1824 <https://github.com/kishanmanali1824> and friends, Please check the latest version at v1-10.0 branch. I will merge this branch into master after your confirmation. Thanks :) — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#12 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AS5TBNhR-E6SCXGrq6_lGiaU19vuL_SQks5s6U19gaJpZM4KCSPG> .

Kishan1824 · 2017-11-27T06:11:27Z

Respected @nagarajanchinnasamy

Its working fine for Row Sub-Total Display Below Property.
Thanks for great work.
Now can i achieve this below requirement in same updation.
Please check my below issue.

I want demo1.png image report type Row & Column Sub-Total Label in our new demo2.png report.
Please check both images.

Kishan1824 · 2017-11-27T09:12:06Z

Respected @nagarajanchinnasamy

I found one issue in updation.
See my attachment.
Waiting for reply.

nagarajanchinnasamy · 2017-11-27T12:44:49Z

@KishanManali1824 Thanks for testing :)

Thats not an issue. Its an enhancement implemented to show the details in the same line when the number of children is one. In your case, RAIL has only one child NORTH. So, the details of NORTH and RAIL will be same. Instead of repeating the same details for RAIL and NORTH, we now show the details in one single row. Hope that explains.

Kishan1824 · 2017-11-28T04:10:01Z

Respected Thats ok,now can we achieve that Row-Sub-Total & Column-Sub-Total Header Label as i described before on github?.

…

On Mon, Nov 27, 2017 at 6:14 PM, Nagarajan Chinnasamy < ***@***.***> wrote: @KishanManali1824 <https://github.com/kishanmanali1824> Thanks for testing :) Thats not an issue. Its an enhancement implemented to show the details in the same line when the number of children is one. In your case, RAIL has only one child NORTH. So, the details of NORTH and RAIL will be same. Instead of repeating the same details for RAIL and NORTH, we now show the details in one single row. Hope that explains. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#12 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AS5TBKv-Bp0OxYwEl59UXWgXVdjZ6-blks5s6q7CgaJpZM4KCSPG> .

nagarajanchinnasamy · 2017-11-28T20:54:39Z

@KishanManali1824

Thats not addressed in this version. Please create a new issue to track it separately.

One small request :) Please feel free to address me as @nagarajanchinnasamy 👍

Kishan1824 · 2017-11-29T04:35:47Z

@nagarajanchinnasamy <https://github.com/nagarajanchinnasamy> Ok.I have created new issue related to Row Sub-Total Header Label implementation on github. refer link : #53 Waiting for positive reply.

…

On Wed, Nov 29, 2017 at 2:24 AM, Nagarajan Chinnasamy < ***@***.***> wrote: @KishanManali1824 <https://github.com/kishanmanali1824> Thats not addressed in this version. Please create a new issue to track it separately. One small request :) Please feel free to address me as @nagarajanchinnasamy <https://github.com/nagarajanchinnasamy> 👍 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#12 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AS5TBBSAxNSAKjvKVxRcCVErwL4ScG2Eks5s7HMRgaJpZM4KCSPG> .

* [#38] Initial Expand/Collapse Behavior * [#38, #12] Initial Expand/Collapse Behavior, Row subtotal at bottom * rowSubtotalDisplay.displayOnTop: true/false introduced * subtotal at bottom - row collapse implemented * bug fixes when using combinations of options * complete rewrite * code cleanup * code cleanup * code cleanup * code refactoring * code refactoring * Code refactoring * code re-factoring * code cleanup * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring * code refactoring

Kishan1824 · 2017-12-07T06:33:16Z

@nagarajanchinnasamy I want to show the row sub-total when the number of children is one. Currently when children is one then that row sub-total not coming. Please help as needed. Waiting for positive reply. On Nov 27, 2017 6:14 PM, "Nagarajan Chinnasamy" <[email protected]> wrote: @KishanManali1824 <https://github.com/kishanmanali1824> Thanks for testing :) Thats not an issue. Its an enhancement implemented to show the details in the same line when the number of children is one. In your case, RAIL has only one child NORTH. So, the details of NORTH and RAIL will be same. Instead of repeating the same details for RAIL and NORTH, we now show the details in one single row. Hope that explains. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#12 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AS5TBKv-Bp0OxYwEl59UXWgXVdjZ6-blks5s6q7CgaJpZM4KCSPG> .

nagarajanchinnasamy · 2017-12-07T06:59:25Z

@KishanManali1824

In the latest v1.11.0-alpha.0 release now we show subtotal when a parent number of children is 1. Please check and let me know if there are any issues.

Thanks for your feedback 👍

Kishan1824 · 2017-12-07T10:57:22Z

Hey @nagarajanchinnasamy <https://github.com/nagarajanchinnasamy> Its working fine.Thanks for updation. You are working like champ😎. One small request can we export the same pivot html wihout those expand/collapse icon in excel. I have already done it but some issue's going. can u help in it. Waiting for positive reply.

…

On Thu, Dec 7, 2017 at 12:29 PM, Nagarajan Chinnasamy < ***@***.***> wrote: @KishanManali1824 <https://github.com/kishanmanali1824> In the latest v1.11.0-alpha.0 release <https://github.com/nagarajanchinnasamy/subtotal/releases/tag/v1.11.0-alpha.0> now we show subtotal when a parent number of children is 1. Please check and let me know if there are any issues. Thanks for your feedback 👍 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#12 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AS5TBH8SfA7vrom12nPjSQ-D6K92rbe3ks5s94zOgaJpZM4KCSPG> .

nagarajanchinnasamy · 2017-12-07T21:36:20Z

Pls create a separate issue regarding download. Thanks :-)

Kishan1824 · 2017-12-08T04:30:06Z

OK. i will create a separate issue for that. Also created another issue regarding sub-total header label. Check & confirm. Waiting for positive reply.

…

On Fri, Dec 8, 2017 at 3:06 AM, Nagarajan Chinnasamy < ***@***.***> wrote: Pls create a separate issue regarding download. Thanks :-) — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#12 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AS5TBIDvC3wS6vjWZiBwVqsGyvq-hJbUks5s-FpVgaJpZM4KCSPG> .

Kishan1824 · 2017-12-08T04:44:21Z

Respected Please refer both this two link: #53 #55 On Fri, Dec 8, 2017 at 10:00 AM, Kishan Kadam <[email protected]> wrote:

…

OK. i will create a separate issue for that. Also created another issue regarding sub-total header label. Check & confirm. Waiting for positive reply. On Fri, Dec 8, 2017 at 3:06 AM, Nagarajan Chinnasamy < ***@***.***> wrote: > Pls create a separate issue regarding download. Thanks :-) > > — > You are receiving this because you were mentioned. > Reply to this email directly, view it on GitHub > <#12 (comment)>, > or mute the thread > <https://github.com/notifications/unsubscribe-auth/AS5TBIDvC3wS6vjWZiBwVqsGyvq-hJbUks5s-FpVgaJpZM4KCSPG> > . >

nagarajanchinnasamy added the enhancement label Sep 28, 2016

nagarajanchinnasamy mentioned this issue Nov 1, 2016

row subtotal at bottom #13

Closed

nagarajanchinnasamy mentioned this issue Feb 3, 2017

Being able to hide subtotals columns when expanding. #26

Closed

nagarajanchinnasamy mentioned this issue May 6, 2017

sub-total display problem #35

Closed

nagarajanchinnasamy mentioned this issue Sep 22, 2017

Hope to see option to be added for Subtotal to appear at the bottom too #49

Closed

nagarajanchinnasamy added a commit that referenced this issue Sep 25, 2017

[#38, #12] Initial Expand/Collapse Behavior, Row subtotal at bottom

87b352b

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Put Row SubTotals at Bottom Instead of Top #12

Put Row SubTotals at Bottom Instead of Top #12

j8lp commented Sep 21, 2016

nagarajanchinnasamy commented Sep 28, 2016

Dams591 commented Dec 28, 2016

Dams591 commented Dec 28, 2016

nagarajanchinnasamy commented Jan 31, 2017

nagarajanchinnasamy commented Jan 31, 2017

nagarajanchinnasamy commented Feb 2, 2017

Dams591 commented Feb 2, 2017

nagarajanchinnasamy commented Feb 2, 2017

nagarajanchinnasamy commented Feb 2, 2017

nagarajanchinnasamy commented Feb 4, 2017

Kishan1824 commented May 8, 2017

Kishan1824 commented Jun 6, 2017

Dams591 commented Aug 14, 2017

nagarajanchinnasamy commented Sep 17, 2017

hkbeer commented Sep 20, 2017

nagarajanchinnasamy commented Sep 30, 2017

Kishan1824 commented Oct 4, 2017 via email

nagarajanchinnasamy commented Nov 26, 2017 •

edited

Loading

Kishan1824 commented Nov 27, 2017 via email

Kishan1824 commented Nov 27, 2017

Kishan1824 commented Nov 27, 2017

nagarajanchinnasamy commented Nov 27, 2017

Kishan1824 commented Nov 28, 2017 via email

nagarajanchinnasamy commented Nov 28, 2017

Kishan1824 commented Nov 29, 2017 via email

Kishan1824 commented Dec 7, 2017 via email

nagarajanchinnasamy commented Dec 7, 2017

Kishan1824 commented Dec 7, 2017 via email

nagarajanchinnasamy commented Dec 7, 2017

Kishan1824 commented Dec 8, 2017 via email

Kishan1824 commented Dec 8, 2017 via email

Put Row SubTotals at Bottom Instead of Top #12

Put Row SubTotals at Bottom Instead of Top #12

Comments

j8lp commented Sep 21, 2016

nagarajanchinnasamy commented Sep 28, 2016

Dams591 commented Dec 28, 2016

Dams591 commented Dec 28, 2016

nagarajanchinnasamy commented Jan 31, 2017

nagarajanchinnasamy commented Jan 31, 2017

nagarajanchinnasamy commented Feb 2, 2017

Dams591 commented Feb 2, 2017

nagarajanchinnasamy commented Feb 2, 2017

nagarajanchinnasamy commented Feb 2, 2017

nagarajanchinnasamy commented Feb 4, 2017

Kishan1824 commented May 8, 2017

Kishan1824 commented Jun 6, 2017

Dams591 commented Aug 14, 2017

nagarajanchinnasamy commented Sep 17, 2017

hkbeer commented Sep 20, 2017

nagarajanchinnasamy commented Sep 30, 2017

Kishan1824 commented Oct 4, 2017 via email

nagarajanchinnasamy commented Nov 26, 2017 • edited Loading

Kishan1824 commented Nov 27, 2017 via email

Kishan1824 commented Nov 27, 2017

Kishan1824 commented Nov 27, 2017

nagarajanchinnasamy commented Nov 27, 2017

Kishan1824 commented Nov 28, 2017 via email

nagarajanchinnasamy commented Nov 28, 2017

Kishan1824 commented Nov 29, 2017 via email

Kishan1824 commented Dec 7, 2017 via email

nagarajanchinnasamy commented Dec 7, 2017

Kishan1824 commented Dec 7, 2017 via email

nagarajanchinnasamy commented Dec 7, 2017

Kishan1824 commented Dec 8, 2017 via email

Kishan1824 commented Dec 8, 2017 via email

nagarajanchinnasamy commented Nov 26, 2017 •

edited

Loading