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.
The current RadPivotGrid handles sum, count, etc. but does not handle 'distinct count'. To elaborate: a field contains numerous different values that are duplicated over a number of rows - 'distinct count' counts the number of distinct values in the record set. Looks like someone has already submitted a similar question/request: http://www.telerik.com/forums/count-distinct-aggregate Hope it makes it into a future release. :-) Many thanks,
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.
It will be useful to have sorting feature in PivotGridAggregateField. For example as in attachment one may want to sort the grades of students as me :) Looking forward to have sorting feature in new releases.
Using RadPivotGrid with million and more records in data source, performance is very poor, and memory/CPU consumption/utilization goes very high. Is there a way to optimize data loading in this control?
When adding a calculated column to give you something like the Avg Price. The column appears across the whole pivot grid. So say you have your totalprice and qty showing for different stores. So the grid groups by stores. When you add the grandtotal calculation you get a new column added to each store. I don't want the avg price added to each store .. I only want to see the average price in the grand totals section to the right? Thanks.
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.
Would be good if ajax pivotgrid filter window supported OLAP dimension hierarchies The Filter window / popup, doesn't seem to respect an OLAP dimension hierarchy. It just shows a flat list at top level (for example case of date hierarchy just shows year). See attached for a date hierarchy example in three different cube browsers, each with the same OLAP SSAS backend. Browsers are a) ajax pivot grid, b) kendo pivot grid and c) excel The Ajax version just shows flat list, whereas kendo pivot and excel show the hierarchy Thanks Chris
1) want to Set Column Resize for Pivot grid same like Rad Grid. Is there any way to do Column resize at runtime same like Rad grid. Customer wants the pivot grid column should be resized at runtime same like the RAD Grid.Which will be more easy and user friendly for the Customers. 2) Need Key board Navigation in Pivot grid same like Radgrid. Customer want Keyboard Navigation for Pivot Grid same like rag Grid.its hard for the customers to use scrolling for every time to see the large no of columns . Is there any way to do Key board Navigation for the Pivot grid.
I want to display multiple grand totals with different aggreagtes. For example I want to have 3 Aggregate rows which are displaying MIN of each field, MAX of each field and AVG of each field
Hi Telerik Team, I want to make a hierachy in PivotGridColumnField as in screenshot (pivotgrid_desired.png). I made a GradeBook project. It holds Student Names, Exam Names,Parent Exam Names, and Grades as in ( gradebook.rar ) . My pivotgrid screenshot is in ( pivotgrid.png ). I googled and read PivotGrid online documents but I couldn't find how to make hierarchy in columns as (pivotgrid_desired.png). Looking forward for your solution. Thanks.