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.