Selective subtotals

8 posts, 0 answers
  1. Darran
    Darran avatar
    5 posts
    Member since:
    Mar 2015

    Posted 01 Jun 2015 Link to this post

    Hi,

     I want to be able to hide a subtotal for particular fields within the pivot.

     I know I can use RowSubTotalsPosition="None" against the RadPivotGrid but that hides all subtotals.

     For instance, if a user adds both Customer Account and Customer Name to the pivot grid then I want to be able to suppress the subtotal of Customer Account. However, there could be an outer group (e.g. sales representative) that would want a subtotal.

     Is this possible?

     Many thanks,

    Darran

  2. Kalin
    Admin
    Kalin avatar
    1353 posts

    Posted 04 Jun 2015 Link to this post

    Hello Darran,

    I'm afraid that with the current implementation of the control is not possible to hide only specific subtotals - you would need to hide them all.

    If you have any other questions or concerns, please let us know.

    Regards,
    Kalin
    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
  3. Darran
    Darran avatar
    5 posts
    Member since:
    Mar 2015

    Posted 04 Jun 2015 in reply to Kalin Link to this post

    Hi Kalin,

     I was afraid that was the case.

     However, is that it? This is pretty useful, standard behaviour. I can imagine it would take some re-engineering of the objects, but it's pretty fundamental to pivot functionality.

     Ideally this option should present itself via the existing dialogues on the PivotFieldList.

     What do you think?

    Cheers,

    Darran

  4. Kalin
    Admin
    Kalin avatar
    1353 posts

    Posted 09 Jun 2015 Link to this post

    Hello Darran,

    Thanks for your feedback. I have logged that in our feedback portal as feature request. This way you would be able to easily vote for it and track its status on the following link:
    http://feedback.telerik.com/Project/143/Feedback/Details/160700-provide-a-way-to-show-hide-particular-subtotals-of-pivotgrid

    If you have any other questions or concerns, let us know.

    Regards,
    Kalin
    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
  5. Stefania
    Stefania avatar
    154 posts
    Member since:
    May 2013

    Posted 07 Mar 2018 in reply to Kalin Link to this post

    Hi

    Any news about this functionality?

  6. Kalin
    Admin
    Kalin avatar
    1353 posts

    Posted 12 Mar 2018 Link to this post

    Hello Stefania,

    The item is not in our plans for upcoming release (R2 2018). Please follow the Feedback item in order to get notified when there is an update.

    Meanwhile can you please explain the scenario you want to achieve (Which totals you need to hide?), all the available feedback will be considered once the feature is being implemented.

    I'm looking forward to your reply.

    Regards,
    Kalin
    Progress Telerik
    Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
  7. Stefania
    Stefania avatar
    154 posts
    Member since:
    May 2013

    Posted 28 Mar 2018 in reply to Kalin Link to this post

    Please refer to your "Pivot grid Layout" demo
    The aggregates fields are "Quantity" and "Net". By default the Pivot grid add the subtotal column for each field.
    I would like to decide on which ones fields I want to show the subtotals. For example the Net field.

    In my scenario I have pivot with 20 aggregations and 3 column groups.
    When I enable subtotals, a lot of columns will be added and the pivot is unreadable. So I need to show subtotals only for a few columns...  

    Excel allow you to enable subtotals on specified columns, and choose one or more operators (sum, count, ecc)  
  8. Kalin
    Admin
    Kalin avatar
    1353 posts

    Posted 30 Mar 2018 Link to this post

    Hello Stefania,

    Thanks for the feedback - it will be considered for the implementation of this feature.

    If you have any other questions or concerns - please let us know.

    Regards,
    Kalin
    Progress Telerik
    Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
Back to Top