Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
Hi,
To expand/collapse a certain header, please use javascript to find your header, then trigger the click event of its expand/collapse icon. Similarly, you could change the Total text of your column header. So in your case, I would try adding this to the end of your page:
<script type=\"text/javascript\">
KoolReport.load.onDone(function() {
var colHeaders = document.querySelectorAll(".pivot-column-header");
var currentYearHeaders = null;
for (var i=0; i<colHeaders.length; i+=1) {
if (colHeaders[i].textContent.trim() == 2019) {
currentYearHeaders = colHeaders[i];
}
if (colHeaders[i].textContent.trim() == "Margen") {
colHeaders[i].textContent = "TOTAL";
}
}
var icon = currentYearHeaders.querySelector(".fa");
icon.click();
} );
</script>
There could be bug in my code but the idea stands. Please use your browser deveveloper console (F12) to debug it if needed. Let us know if you have any difficulty. Thanks!
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo