Grand Total in the upper part of the Pivot

Comments

3 comments

  • Avatar
    Meredith Admin

    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.

    0
    Comment actions Permalink
  • Avatar
    Dave Stearns

    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);

    }

    });

    0
    Comment actions Permalink
  • Avatar
    Meredith Admin

    Our engineer tried it and it doesn't seem to work as expected. She will keep messing around with it but doesn't think it's whta we need. Thanks, Dave!

    0
    Comment actions Permalink

Please sign in to leave a comment.