Aggregate functions that uses the results of sibling functions

5 posts, 0 answers
  1. Oana
    Oana avatar
    4 posts
    Member since:
    Apr 2018

    Posted 04 Apr 2018 Link to this post

    Does anybody know if the results from sibling aggregate functions can be used as input values for another function?

    I would like to display the following grid:

                              Day 1                                 

                              Aggr1     Aggr2    Diff
      Shop               v1            v2         v1-v2
           Item A        p1A         p2A
           Item B        p1B         p2B

     

    Is there any way to access the Aggr1 and Aggr 2 results in the Diff aggregate?

  2. Oana
    Oana avatar
    4 posts
    Member since:
    Apr 2018

    Posted 10 Apr 2018 Link to this post

    I wonder if any admins have got a chance to look over this questions. Any answer will be highly appreciated, even if the answer is: "no, this scenario cannot be implemented in RadPivotGrid"

     

    Thanks!

  3. Martin Ivanov
    Admin
    Martin Ivanov avatar
    2424 posts

    Posted 13 Apr 2018 Link to this post

    Hello Oana,

    Maybe you can try the Calculated Fields feature and see if this would work in your scenario. You can also check the Calculated Items article.

    Regards,
    Martin Ivanov
    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.
  4. Oana
    Oana avatar
    4 posts
    Member since:
    Apr 2018

    Posted 16 Apr 2018 in reply to Martin Ivanov Link to this post

    Thanks Martinf for the recommendation!

    I checked the Calculated Fields and it seems that they can only access data from either properties or Sum Aggregates, but I need to access results from custom aggregates. I tried going through the list of summaries programmatically but the objects are inaccessible. 

    Are there any other options of accessing custom aggregates from Calculated Fields?

  5. Martin Ivanov
    Admin
    Martin Ivanov avatar
    2424 posts

    Posted 19 Apr 2018 Link to this post

    Hello Oana,

    Currently, I can't suggest you a working solution for achieving your requirement. There is a request for introducing a feature that should be useful in your scenario. You can find a bit more on this in the following forum.

    Regards,
    Martin Ivanov
    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