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.

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

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

When try to expand inner group I get an error: System.InvalidOperationException: Sequence contains no elements.

Stack trace:
[InvalidOperationException: Sequence contains no elements]
   System.Linq.Enumerable.First(IEnumerable`1 source) +309
   Telerik.Web.UI.RadPivotGrid.AddRemoveCollapsedGroupIndexBySlot(PivotGridGroupSlot groupSlot, BaseLayout layout, HashSet`1 indexes, Boolean defaultExpanded) +287
   Telerik.Web.UI.RadPivotGrid.HandleExpandCollapse() +332
   Telerik.Web.UI.RadPivotGrid.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) +484
   System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +67
   System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +123
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +33
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +138
   Telerik.Web.UI.RadPivotGrid.PerformSelect() +49
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +30
   Telerik.Web.UI.RadPivotGrid.DataBind() +106
   Telerik.Web.UI.PivotGridExpandCollapseEventArgs.ExecuteCommand(Object source) +727
   Telerik.Web.UI.RadPivotGrid.OnBubbleEvent(Object source, EventArgs args) +205
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   Telerik.Web.UI.PivotGridItem.OnBubbleEvent(Object source, EventArgs args) +121
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +114
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +159
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

Note. This happens only whe I try to expand second level in group. ColumnGroupsDefaultExpanded and RowGroupsDefaultExpanded properties ot PivotGrid is set to "false" by default.

Summarize By Settings dialogue is not supported with OLAP functionality.

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?

When setting datasource if the data is a dynamic type it wont render anything.

My type is IEnumerable<dynamic>

Cheers