Add increased customisation opportunities to the Configuration Panel in the RadPivotGrid: Allow sorting of "All Fields" Allow addition of fields to "All Fields" collection without adding to Filter / Row / Group / Aggregate Zones User specified dimensions of Filter / Row / Group / Aggregate sections
I have a scenario in my web application where I need possibility to sort values in RadPivotGrid by field existing in datasource, but is not displayed in RadPivotGrid. For Example I have flats that should be sorted in order defined in field sort_order, I can add this field to RadPivotGrid, but I don't want to show it to user. This approach works perfectly with standard RadGrid, but unfortunately does not work with RadPivotGrid. Flats are sorted by their names, with is wrong from my point of view.
Some of the most powerful features of the new RadPivotGrid are based around aggregates. It would be great if you could simply sort by any aggregate fields set up, including Grand Totals. I have not seen any documentation on doing this as it stands.
If you call Page.DataBind() in the Page_Load event handler of a page that has a RadPivotGrid on it that has an event handler for OnNeedDataSource, the OnNeedDataSource event isn't raised when the page is loaded. This behavior is different than that of other controls such as RadGrid. In my opinion it is confusing and the behavior should be the same. You may have other controls on the page that you want to data bind. So, I think it is reasonable that you should be able to call DataBind() and use advanced binding with RadPivotGrid at the same time. Also, I noticed that if you don't call DataBind(), the OnNeedDataSource event is raised twice. Please see the Visual Studio 2012 project that I attached to this bug report for example code. Set break points in the NeedDataSource event handlers for the RadPivotGrid and RadGrid controls and run the application in debug mode to see the behavior. Comment and uncomment the call to DataBind() in Page_Load().
The Telerik blog posting at http://blogs.telerik.com/xamlteam/posts/12-12-21/introducing-radpivotgrid-for-wpf-silverlight describes how to add "calculation" fields to a RadPivotGrid for WPF/Silverlight. As far as I can tell, the current version of RadPivotGrid for ASP.NET AJAX doesn't have this feature. Please add this feature to the RadPivotGrid for ASP.NET AJAX. I need it in order to add percentages to a RadPivotGrid similar to what is described in the Calculations section in the blog entry.