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.
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.
If a group has only one item in it, I only want to show the total row and not being able to expand it.
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.
As a user I want to hide the Grand Totals for specific groups.
The caption sounds ocnfusing, but i couldn't come up with a better one:
Problem is, if you have hirarchical data like Date.Calendar, you have "sub" values that can be collapsed and expanded
Problem is, when you have more headers, that sit below therese hirarchies, they will be collapsed too.
In this example, "Category" sits below there.
See how the Category is not visible, because Icollapsed the whole year 2010.
Compare that to 2011 where all categories are visible, because its fully expanded.
The feature I am requesting here is to still be able to show columns for each category and aggregated values, even though the year is collapsed.
I know this would be acchieved by moving category on top of the headers, but this also changes orders of the columns.
Our old windows forms pivot grid had this kind of functionality.
MSPaint to the rescue, this is how I imagine it (ignore the numbers, they do not make sense)
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)