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.

In RadPivotGrid control can be intresting have a Virtual scrolling and paging like RadGrid control.

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,

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?

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. 

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.

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.

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.

Currently, you have ColumnGroupsDefaultExpanded and RowGroupsDefaultExpanded available for the PivotGrid.

I would like to request an ExpandedGroupsBehavior that allows you to set a particular level to expand to.

To better explain this, the WPF PivotGrid has this. Here is a the documentation: http://docs.telerik.com/devtools/wpf/controls/radpivotgrid/features/expand-behavior.html

Thank you

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

The aggregates functions highlighted in the attached screenshots have common names that are used in the industry and as such they are not localized. This feature request is so that their names can be localized through global resx files along with other strings in the RadPivotGrid control.

In the meantime, you can use the ItemDataBound event to change cell texts based on your requirements. You can find similar examples here: https://demos.telerik.com/aspnet-ajax/pivotgrid/examples/appearance/conditionalformatting/defaultcs.aspx
For example, to change the Sum aggregate name in the column header, you can do this:
            else if (e.Cell is PivotGridColumnHeaderCell)
            {
                PivotGridColumnHeaderCell cell = e.Cell as PivotGridColumnHeaderCell;
                cell.Text = cell.Text.Replace("Sum ", "custom ");

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.