ivan77 Posted July 31 Report Share Posted July 31 Hi, How can I insert Group name on Subtotal aggregation Label ? Please see image below I want : Subtotal BENSIN , Subtotal PARKIR GRAHA for the aggregation label Rgds, Quote Link to comment Share on other sites More sharing options...
0 CoopperBackpack Posted August 1 Report Share Posted August 1 Hello @ivan77, As I can see the field you mentioned is the second field and grouping is applied to the 1st and 2nd fields. If this is correct, you may test the following solution: 1) As of now you have the 'No Label' Group aggregation label as far as I understand 2) This code should be added to the Footer section of the Results page (disable the HTML editor on the Advanced tab before pasting the code): <script> document.addEventListener('DataPageReady', function (event) { let secondGroupLabels = document.querySelectorAll('td[class*="cbResultSetGroup2Label"]'); let subtotalLabel = document.querySelectorAll('td[class*="cbResultSetGroup2SubTotal"]'); secondGroupLabels.forEach((label, index) => { subtotalLabel[index].innerText = 'Sub Total ' + label.innerText; }); }); </script> Hope this helps! ivan77 1 Quote Link to comment Share on other sites More sharing options...
0 ivan77 Posted August 1 Author Report Share Posted August 1 Yes it Works, Thanks a lot @CoopperBackpack CoopperBackpack 1 Quote Link to comment Share on other sites More sharing options...
Question
ivan77
Hi,
How can I insert Group name on Subtotal aggregation Label ? Please see image below
I want : Subtotal BENSIN , Subtotal PARKIR GRAHA for the aggregation label
Rgds,
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.