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.
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.
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
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.
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.
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
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.
It seems that the option to turn of sums has no effect for hirachie columns.
No matter if this option is checked or not, they do not disappear.
It works on regular columns.
The DistinctValuesLimit property is available in our R1 2018 Release.
Available in LIB version 2016.2.606, it will be also available in the 2016 R2 SP1 release.