Getting subtotal for each and every level of a column.

[WSAyan]

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.

[nagarajanchinnasamy]

Hi @WSAyan

Thanks for your interest in Subtotal.js 👍

This library provides support for both row-wise and column-wise subtotal. Have you checked the examples here.

Please explain your requirement using one of the examples. So that I am able to understand your requirement better.

[WSAyan]

Sorry for the unclear question. I was a bit confused about what I want. I am trying to ad calculated column fields based on user calculation. So far I've been able to calculate percentage of C _WEALTH_RANK_A based on G_WEALTH_RANK_TOTAL as you can see them on following screenshot. And the calculation works fine but the problem is when Subtotal.js calculating all the values according to its attributes (eg: sum,integer sum,count) . So I guess what I need is to get subtotal values of a column in each and every level so that I can calculate another calculated column field based on those subtotal values.

PS: I am changing the name of the issue as it is irrelevant to the topic. Again sorry for such a stupid question.

[nagarajanchinnasamy]

@WSAyan Thanks for the explanation. If I understood your requirement correct, I think, its same as issue: #41 Aggregator on the subtotal only.

Please confirm my understanding is correct or not.

[WSAyan]

Yes it is pretty much same issue. Thanks a lot. 👍