When the RadPivotGrid is Ajaxified from the RadAjaxManager, the paging functionality doesn't work as intended.

Steps to reproduce: 

1. Have an Ajaxified PivotGrid
2. Change the page size (from 10 to 20)
3. Click the go to next/previous page or first/last page button

The issue can be replicated in the OLAP and KPIs Support demo.

Steps to replicate the issue:

• Add an item to the "Row Fields" by checking the checkbox of the item in the "All Fields" panel
• Remove the item from the "Row Fields" by unchecking the checkbox of the item in the "All Fields" panel
• Click the Update button
• After the PostBack the PivotGrid will display the Item in the "Row Fields" despite it was removed soon after adding it.

While working on pivot grid, we observe that the filtering condition is applied. But there is no visual indicator showing that the current pivot has applied a filtering condition on a given column.

For instance, the following captured picture is obtained from the demo page. I selected Beverages in the "Category" filter and applied it to the pivot grid.

• https://demos.telerik.com/aspnet-ajax/pivotgrid/examples/firstlook/defaultcs.aspx 

However, there is no visual clue to tell me how many filtering columns are been used at the moment.

Here is how the filtered and non-filtered fields appear in MS Excel:

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.

The appearance problem can be seen on http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/firstlook/defaultcs.aspx.

Click on the filter icon for Product name, you will find that the save and cancel buttons are off-screen. And if you hover over Label Filters or Value Filters the window is not wide enough to fit the popout menus that show:

Biff export (RadTreeList, RadGrid, RadPivotGrid) throws an "Out of Memory" exception when exporting from application hosted on Azure. 

Summarize By Settings dialogue is not supported with OLAP functionality.

Hi I have a straightforward feature request: I would like to be able to "get" the row/column "filter" values the user has selected server-side. Basically need a public property or some type of getter. Currently on the PivotGrid, the row/column "Filter" "Includes/Excludes" can be "set" programmatically, but user selected values can't be easily gotten.

I would use it in a couple ways: 

1) to display context to the user for the numbers in the grid. (e.g., show the user the active filter values responsible for the numbers they are seeing in the PivotGrid Detail). 

2) I need the filter values to close Ticket 1168787.

A Telerik employee make a nice sample project to do drill-through functionality: https://www.telerik.com/blogs/how-to-implement-drill-down-functionality-in-telerik-s-pivotgrid-for-asp.net-ajax-part-2

But the PivotGrid counts and RadGrid detail data records returned are not in agreement because selected PivotGrid filters aren't applied to the detail returned in the RadGrid. I need to do that. I need to be able to mimic a drill through action into the detail records that make up the data counts. If I click a cell that says "100" (orders, 2018 year included) I need 100 orders returned in the detail. Not 7000 orders (all order years, unfiltered).

In that ticket, I'm trying to mimic the functionality similar to an SSAS "drillthrough action" (like many cube browsers have built in, e.g., RANET OLAP), except here with a regular SQL data source. This way I can drill into the detail records that make up the numbers displayed to the user in the PivotGrid. However, as it stands, the counts and detail will not be congruent until I can get the filter values selected by the user and apply them accordingly to the data set for the detail RadGrid. The BI users expect to be able to drill into the data and I need to provide it.

Thank you,

Tom

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?

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.

Hi Team,

Using Persisting Pivot Settings : Filter Settings is being saved in filter window after clicking cancel button
(Ex : http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/applicationscenarios/persisting-radpivotgrid-settings/defaultcs.aspx?product=persistenceframework)

1. Click on any filter icon in Pivot Grid (CategoryName filter icon)
2. Deselect first item from the list in pop up window (like Beverages)
3. Click Cancel
4. Filter is not applied on Pivot Grid which is perfect
5. Click on same filter icon (CategoryName filter icon) 
6. Observe that it is still showing first item as not selected (though the filter was cancelled and is not present on grid as well)

Expected : When we click cancel on Filter Window, the changes done should be removed.

One of my PivotGridColumnField's is a smalldatetime field from SQL Server.

In the PivotGrid column header labels I want the dates to be formatted as MMM-yy,  like Aug-15.

I can accomplish that for the detail columns (the non-aggregate columns) by setting the DataFormatString="{0:MMM-yy}"

But that format string is NOT applied to the label of the column total header.  The aggregate column header label still reads:  "08/01/2015 00:00:00 Total"

If you allow a custom format to the detail column headers, it would be logical to assume I want that same custom format used in the aggregate column header.  So in my example, that label should display:   Aug-15 Total

I was told in the Forum that I'd have to parse that column header string in the  CellDataBound Event to get the date portion and then format it and use that to set the header text.  That is a very UGLY solution.

I don't want to strip the word "Total" out of that string and then then convert the date that remains to a string in the date format I want. 

Thanks,
Brent