Pivotgrid Total Settings

2 posts, 0 answers
  1. Kristel
    Kristel avatar
    1 posts
    Member since:
    Jan 2012

    Posted 05 Nov 2013 Link to this post

    I do want sub total rows but only with one level of grouping.  If I turn off subtotal grouping I loose the one total I want to display.  If i have Rows sub total position on I have extra row total fields I do not want.  Is there anyway to control this?  For example based on my screen shot I want to to display the InstName total for each section but Not the AUN, CIP, Program etc.
  2. Daniel
    Daniel avatar
    4949 posts

    Posted 11 Nov 2013 Link to this post

    Hello Kristel,

    I noticed that the same question has been submitted by another account in a support ticket.
    Unfortunately, there is no way to hide individual totals and show others without breaking the RadPivotGrid layout. In such case your best options is to leave all totals visible. You could optionally empty the cell text in the RadPivotGrid CellDataBound event by checking if the e.Cell.Text equals a total that you do not want visible and setting the e.Cell.Text as empty string.

    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Back to Top