Users should be able to select individual or multiple cells of RadPivotGrid. Available in the 2016 R3 Release. Please take a look at our help article for more information: http://docs.telerik.com/devtools/wpf/controls/radpivotgrid/features/selection
Similar to Excel - RadPivotGrid could have an area, where you can select some filter/group descriptions.
Implement functionality to show a break down of items that aggreagate to current cell. Available in the 2017 R1 Release (2017.1.117). For more reference you can check the following help article: http://docs.telerik.com/devtools/wpf/controls/radpivotgrid/features/localdatasourceprovider/drilldown
Currently it is only possible to either show all or hide all subtotals.
If a group has only one item in it, I only want to show the total row and not being able to expand it.
Add support for frozen columns. Like in RadGridView or Excel. This way you can scroll the data horizontally while part of the columns are frozen and you can always see them.
We can also consider adding frozen rows like in RadGridView or Excel.
As a user I want to hide the Grand Totals for specific groups.
Currently when you have null value in a cell, RadPivotGrid considers it as 0. This way when you apply some Aggregate Functions, like Average for example, the result may not be as expected. For example if you have the cells 10, null, 10 RadPivotGrid will show as total the value 6.67 (for Average function). You should be able to exclude null values, so the value 10 will be shown as average for the mentioned cells. Available in the 2016 R2 release.
Currently when a header value is empty the displayed text is "(blank)" regardless of the application's culture. Localize this value or allow the developer to set this value more easily. If you want to manually localize the "(blank)" text you can define a RowHeaderTemplate and ColumnHeaderTemplate (or template selector) and replace the default text with its translation. You can do that via IValueConverter. (http://docs.telerik.com/devtools/wpf/controls/radpivotgrid/styles-and-templates/templating-cells#using-custom-cell-and-header-templates)
I would like RadPivotGrid to sort the dates defined in OLAP Cube as dates, for example: -Week 1 -Week 2 -Week 12 Instead of the current sorting: -Week 1 -Week 12 -Week 2
As a user I would like QueryableDataProvider to avoid blocking the UI while executing the query on the database server.
In the RadPivotGrid: Open the Label Filter dialog on a dimension, don't set anything and press OK, then all items are present and nothing is filtered out as expected. Open the Label filter again and manually specify that the value must equal "xyz" and click OK then it will exclude every item that doesn't match this. Again, this behaviour is what you'd expect. If you then open the dialog, and delete the "xyz" from the textbox so that the dialog appears exactly as it did originally, and click OK then you won't see any items in your pivot grid. This is because it is now filtering out anything that doesn't have an empty string as the label. This is not what I'd expect. To remedy this, you can click on the dimension and see that the Label filter is still ticked in the context menu, and click "Clear filter", but this isn't exactly intuitive. I'd like the filter to be cleared when you clear the text in the box.