Grand Total in the upper part of the Pivot
It would be nice to allow showing Grand Total in the upper part of the Pivot, now to see Grand Total one have to scroll the Pivot all the way down.
-
Taylor Golden from Meredith also has this same request. :) We would like to move the grand total to the top of the pivot table so that the user doesn't have to scroll to the bottom to see since it is a larger pivot. It would be a good function to have for this and other reports in the future.
-
This should be what you are looking for. I implore you to snoop around the developer forums and Google exactly what you need. You will usually find what you are looking for. When you enter your Pivot widget, click on the three dots to "Edit Script" (will open up a new tab), paste this into the field, Save, then go back to your widget, click Apply, then refresh the page. The desired effects will have been applied.
-----------------------------------------------------------
widget.on('ready', function(sender, ev){
if ($(".p-grand-total-row-head", element).length > 0)
{
setTimeout(function(){
$('table#pivot_',element).prepend($('table#pivot_', element).find('tr:last'));
$('div.table-container table', element).prepend($('div.table-container table', element).find('tr:last'));
$('tbody',element).each(function(){
$(this).find('tr:first td').not('.phantom').css('border-bottom', '1px solid #ccc').find($('span, .p-value')).css('font-weight', 'bold');
});
$('.p-grand-total-row-head.p-first-data-col').css('border-left', 'none');
},500);
}
});
Please sign in to leave a comment.
Comments
3 comments