Hiding Sub Totals for Row Items

10 posts, 0 answers
  1. Gerald
    Gerald avatar
    1 posts
    Member since:
    Jul 2011

    Posted 18 Sep 2012 Link to this post

    Hey,

    I have a couple of nested row items and I do not want to the show the totals for each group since they are meaningless to the client.

    Desired Layout 
    Person Name August
    Product
    Budget 15
    Actual 14
    Production 2
    Budget 16
    Actual 16

    Is there a way to hide the Total footers that would show up under the Person Name field and the Product? This is being done with the latest version of the PivotGrid for ASP.NET AJAX
  2. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 21 Sep 2012 Link to this post

    Hi Gerald

    In the current version of RadPivotGrid the required functionality is not implemented. However our developers are actively working on this feature and it would be available for the next official release of the controls which is planned for the second half of October.

    Kind regards,
    Maria Ilieva
    the Telerik team
    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 their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Oliver
    Oliver avatar
    1 posts
    Member since:
    Feb 2013

    Posted 14 Nov 2014 in reply to Maria Ilieva Link to this post

    Has this functionality been implemented? We found that we needed the ability to hide certain row totals from our very first use of RadPivotGrid. I can't see it in the documentation.

    If it has not been implemented, is it scheduled for a future release?
  5. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 20 Nov 2014 Link to this post

    Hello Oliver,

    Unfortunately the required feature is not implemented in the RadPivotGrid control. After deep research on this task our dev team came to a conclusion that this functionality could not be achieved with the core Pivot Engine we are building our control on and for now such functionality will not be added.

    Excuse us for any inconvenience this limitation may lead.

    Regards,
    Maria Ilieva
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  6. Pradeep Deshpande
    Pradeep Deshpande avatar
    8 posts
    Member since:
    Sep 2009

    Posted 02 Jul 2015 Link to this post

    Hi telerik Team, 

      How to change the Aggregate function for specific rows .I am using rowsubtotals and using aggregate as sum for aggregate columns.but want some row subtotals calculated as average instead of sum.Please find the attached screen shot will show oil price is summed up instead of average. 

     

    For example : First 5 rows-subtotal have an aggregate as sum and the price rows need average aggregate.currently i am not able find any property or solution to calculate the average.please help any one have solution

    below is aspx markup

    <telerik:RadPivotGrid ID="RPG_Variance" AllowPaging="false" PageSize="10" Skin="Metro" Height="460px" RowGroupsDefaultExpanded="false" TotalsSettings-RowsSubTotalsPosition="First" RowTableLayout="Outline"
                               AccessibilitySettings-ColumnHeaderTableCaption="" TotalsSettings-ColumnGrandTotalsPosition="None" TotalsSettings-RowGrandTotalsPosition="None"
                               OnCellDataBound="RPG_Variance_CellDataBound" AllowFiltering="false" ShowFilterHeaderZone="false" OnNeedDataSource="RPG_Variance_NeedDataSource"
                               ShowDataHeaderZone="false" runat="server" ShowColumnHeaderZone="false">
                               <ClientSettings EnableFieldsDragDrop="false">
                                   <Scrolling AllowVerticalScroll="true" ScrollHeight="460px" SaveScrollPosition="true"></Scrolling>
                               </ClientSettings>
                               <Fields>
                                   <telerik:PivotGridRowField DataField="Category" CellStyle-Width="200px" SortOrder="None">
                                   </telerik:PivotGridRowField>
                                   <telerik:PivotGridRowField DataField="Budget" CellStyle-Width="200px" SortOrder="None" >
                                   </telerik:PivotGridRowField>
                                   <telerik:PivotGridColumnField DataField="MonthDate" CellStyle-Width="50px" SortOrder="None">
                                   </telerik:PivotGridColumnField>
                                   <telerik:PivotGridAggregateField DataField="Original" Aggregate="Sum" CellStyle-Width="90px" 
                                       DataFormatString="{0:N2}">
                                       
                                   </telerik:PivotGridAggregateField>
                                   <telerik:PivotGridAggregateField DataField="Scenario" Aggregate="Sum" CellStyle-Width="90px"
                                       DataFormatString="{0:N2}">
                                         
                                   </telerik:PivotGridAggregateField>
                                   <telerik:PivotGridAggregateField DataField="Variance" Aggregate="Sum" CellStyle-Width="90px"
                                       DataFormatString="{0:N2}">
                                   </telerik:PivotGridAggregateField>
                                   <telerik:PivotGridAggregateField DataField="Var" Aggregate="Sum" CellStyle-Width="90px"
                                       DataFormatString="{0:N2}%">
                                   </telerik:PivotGridAggregateField>
                               </Fields>
                           </telerik:RadPivotGrid>

     

     

  7. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 07 Jul 2015 Link to this post

    Hi Pradeep ,

    I am afraid this is no a supported scenario. You can have different aggregate functions for the different aggregate fields but not for the different rows. 

    Regards,
    Maria Ilieva
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  8. Robert
    Robert avatar
    25 posts
    Member since:
    Sep 2010

    Posted 09 Jul 2015 Link to this post

    This control is worthless.

     You guys need to stop touting this and many of the Grid features as 'Excel-like',,,because they ALWAYS fall short of the mark. Always. The filter feature is half-baked. The Gantt-control is half baked. This PivotGrid is half-baked. You guys always take your controls to the 75% mark and stop there.

  9. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 14 Jul 2015 Link to this post

    Hi Robert,

     Thank you for your feedback.

    We are doing our best to provide fully functional and features rich controls, however, in some cases not all expected by our client features are added into the control's design. In case we have requests from our customers for any specific functionality we are always open to discuss it with our development team and do the best to implement it if possible.
    You can also use the feedback portal below for adding your feedback:
    http://feedback.telerik.com/project/108

    Regards,
    Maria Ilieva
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  10. Robert
    Robert avatar
    25 posts
    Member since:
    Sep 2010

    Posted 20 Jul 2015 Link to this post

    http://feedback.telerik.com/Error/HandleError?aspxerrorpath=/project/108
  11. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 20 Jul 2015 Link to this post

    Hello Robert,

    The presented link is leading to an error page. Can you please post the correct link for the feedback item you have logged?

    Regards,
    Maria Ilieva
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017