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

PivotGridAggregateField with Calculated DataField

1 Answer 43 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Jose
Top achievements
Rank 1
Jose asked on 01 Nov 2013, 05:40 PM

Hi:

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.

Thanks!

Jose

 

 

 

1 Answer, 1 is accepted

Sort by
0
Antonio Stoilkov
Telerik team
answered on 06 Nov 2013, 12:34 PM
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.

Regards,
Antonio Stoilkov
Telerik
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.
Tags
PivotGrid
Asked by
Jose
Top achievements
Rank 1
Answers by
Antonio Stoilkov
Telerik team
Share this question
or