This is a migrated thread and some comments may be shown as answers.

Aggregate functions that uses the results of sibling functions

4 Answers 24 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Oana
Top achievements
Rank 1
Oana asked on 04 Apr 2018, 07:51 AM

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?

4 Answers, 1 is accepted

Sort by
0
Oana
Top achievements
Rank 1
answered on 10 Apr 2018, 08:26 PM

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!

0
Martin Ivanov
Telerik team
answered on 13 Apr 2018, 11:49 AM
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.
0
Oana
Top achievements
Rank 1
answered on 16 Apr 2018, 07:39 PM

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?

0
Martin Ivanov
Telerik team
answered on 19 Apr 2018, 12:51 PM
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.
Tags
PivotGrid
Asked by
Oana
Top achievements
Rank 1
Answers by
Oana
Top achievements
Rank 1
Martin Ivanov
Telerik team
Share this question
or