PivotGridAggregateField with Calculated DataField

2 posts, 0 answers
  1. Jose
    Jose avatar
    6 posts
    Member since:
    Nov 2013

    Posted 01 Nov 2013 Link to this post


    I am trying to emulate a given Excel pivot table with the
    RadPivotGrid control. This pivot table has a calculated field used on the ‘∑ Values’ section with a ‘SUM’ aggregate function. I haven’t found a way to correctly set the PivotGridAggregateField tag. The formula for the calculated field is to divide other two fields, ex. field1/field2. What happens is that for each row Excel do: sum(field1) / sum(field2).

    I am using ASP.NET 4.5, Windows 8, Internet Explorer 10.0.9200.16721, Telerik v.2013.2.717.45, C#.

    The provided help will be appreciated.







  2. Antonio Stoilkov
    Antonio Stoilkov avatar
    530 posts

    Posted 06 Nov 2013 Link to this post

    Hello Jose,

    We have planned to implement the described functionality in our next Q1 2014 RadControls release. Unfortunately, currently there is no way for achieving the desired scenario.

    Antonio Stoilkov
    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