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,

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 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.

Aggregate functions like Max, Min and Count would be useful in some scenarios with fields of type DateTime.

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

As stated in the title: in RadPivotGrid, user should be able to drag and drop fields directly to row / aggregate / filter fields without having to check them first in the configuration panel. See attached image.

In current situation, user has to (a) first check the box to move the field to e.g. row fields and THEN to drag it to the order they want - this is TWO postbacks.
If this feature was implemented, users could drag the field from the config. panel and drop it directly in the place they want - only ONE postback.

Dragging and dropping is by far the most intuitive way of doing things in the pivot grid (what is "Move to row fields" supposed to mean to an average user???) so please consider this. It is a strikingly missing feature.

Would like to have the ability to remove and add items to a pivot grid's filter window prior to rendering.  Any item added or removed would be persisted/updated to the data-source.

Many requests come from vendors that require certain information to be provided or removed based on user privileges, business rules, user inputs, etc.. 

In an at least two level pivotgrid scenario, it would be nice to have the option of calculating the percentage of the inner level within that level and not based on the grand total (i.e. on the subtotal of the parent). In the attached image we can see that the inner levels have percentages based on the grand total instead of percentages of the category they belong. For example Diprivan should have a percentage of 100% since it is the only element of Astrazeneca. Same goes for Astrazeneca since it is the only element of Anesthetic, General.

We are able to bind the data from OLAP cube by using ADOMD data provider and XMLA data provider. How do we access multiple cubes from RadPivotGrid?