rowGroup multiple data sources (dataSrc)
rowGroup multiple data sources (dataSrc)
mosxe
Posts: 4Questions: 2Answers: 0
Hello.
I apologize for the past topic without examples.
I grouped the rows in the table using "drawCallback". For each grouping, need to calculate the amount.
To calculate the amount I use "rowGroup".
And here I am faced with one problem
In the "rowGroup" in the "dataScr" as I figured out, can specify 1 only the data source (in this case I pass the data in the json- format) and specify the name of the column. It sums it up correctly, but I need to sum up 2 columns, not one.
https://jsfiddle.net/mosxe/ucju154p/1/
https://jsfiddle.net/mosxe/ucju154p/2/
The main problem for me is that I do not know how to specify two data sources in the "RowGroup" "dataSrc:"
To calculate the total for 1 and 2 columns.
Thank you in advance
This question has an accepted answers - jump to answer
Answers
I'm sorry to say that there is no option to specify two different data points for the data source in row group. This is an enhancement request from another thread (which I can't see right now).
However, I'm not sure that a multiple data point source is what you want. Have a look at this example which shows two different columns in the same group being summed and summarised.
Allan
Allan, thanks for the quick response.
Unfortunately, in this example, the sum of the columns is applies for only one grouping specified in "rowGroup" "dataSrc".
While I see one option - is to add one column with the sum and group it through the "drawCallback".
Perhaps there are other options?
Thank you in advance.
I'm afraid I'm not quite getting it. Do you want two levels of grouping? That is indeed, something that RowGroup does not currently provide.
Allan
Yes. Two levels of grouping and for each output the total amount.
Very sorry. I will look for another way to realize the amount.
Ty so much, Allan
Whether multiple levels of row grouping and totalamount for each group Issue resolved. Or Is there any way to resolve the Issue? Can anybody help?
No - as of yet that feature has not been implemented.
Allan
Solution for this is available in
https://datatables.net/forums/discussion/47614/row-grouping-and-its-subtotal-for-multiple-level#latest