Group Name on Subtotal Aggregation label

[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,

[CoopperBackpack]

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]

Yes it Works, Thanks a lot @CoopperBackpack