Currently, the RadPivotGrid does not support reordering the columns and rows groups. We could add support for such functionality similar to the one present in Excel.

Add average/min/max built in functions for DateTime and TimeSpan values

When a label filter is applied and there are repeating groups for columns and rows the GetUnderlyingData method does not return the correct items. 

Currently, RadPivotGrid supports UI-based selection, which highlights the selected cells. However, the API that handles this is internal and it cannot be used to manually access the selection. Add API that allows to get the selected items and to update the selection.

The TotalFormat of a calculated field can be transferred to its required field when both fields are used as aggregate values.

Add API to ignore null values when using the Drill Down functionality

RadPivotGrid is loading all data from OLAP Cube. It should be able to use on demand (lazy loading) pattern, so when a group is expanded, a new query is sent and only required data is taken from the server.

If we apply a label GroupFilter to a RowGroupDescription/ColumnGroupDescription (through the GroupFilter property or through the RadPivotFieldList) matching groups from both the rows and columns are filtered out. 

If you apply a number format to a Count value in the RadPivotGrid, then it is ignored. The reason given is that count is always an integer, so it shouldn't need formatting. However, I'd like to be able to apply group separators. It's much easier to read 100,000,000 than 100000000. 

Similar to Excel - RadPivotGrid could have an area, where you can select some filter/group descriptions.

Currently, the string format (used in the cells generated for the  from the DateTimeGroupDescription) is determined automatically based on the selected Step (Day, Month, etc.). Add an option to easily set custom string format.

At this moment, you can change the format only if you create a custom description and override a considerable amount of code. This is shown in the following SDK example: https://github.com/telerik/xaml-sdk/tree/master/PivotGrid/CustomDateTimeGroupDescription

 

InvalidOperationException regarding QuickStyle Freezable is thrown when the control is opened in new STA thread.

Bug can be reproduced in PivotGrid => Olap Support in demo application.
Under all main categories in the designer, there is a folder called "Sets" that has the exact same content.

It either is mistakingly placed under each "category" or should be something that sits on top of them in a more global fashion.

InvalidDataContractException is thrown when serializing the LocalDataSourceProvider with a DataContractSerializer and a calculation (TotalFormat) is applied.

Currently, changing the visibility of the Expand/Collapse icon, via style, will apply it to all of the elements which are of type PivotGroupHeader.  

add a textbox which allows users to find matching distinc values when using report filters. Very valuable if you are dealing with many distinct values. 

Currently - any string can be typed in the combobox which is displayed as the editor for the label filters. The input should be limited to only the values present in the ItemsSource collection. 

Bug can be observed in Pivot Grid => Olap Sorting example in  the most recent demo.

Sadly i do not know what this menu is called in english (and the demo cannot change language) so here is a screenshot

Set it to 'Equal' 'Lisa Cai'




If you hit ok and refresh, all values are gone.
Weirdly if you change it to not equal, you still get zero results

I've been investigating a memory leak in my application and I've noticed that there are a lot of TypeBuilders and RuntimeTypes hanging around, and this number increases over time. Investigation into this shows that they are being held onto by the ModuleBuilder instance in the static instance of the Telerik PivotClassFactory.