It happens when you change the distinct values selection several times. The PivotGrid disappears after the exception is thrown. I managed to reproduce it in the demo by repeating this action around ten times.
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.
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.
Similar to Excel - RadPivotGrid could have an area, where you can select some filter/group descriptions.
Available in LIB version 2016.2.606, it will be also available in the 2016 R2 SP1 release.
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.
Available in LIB version 2015.2.914, it will be also available in the 2015 Q3.
If you have WriteOnly property in your Data Item and you set a collection of DataItems as ItemsSource of LocalDataSourceProvider, RadPivotGrid and RadPivotFieldList will not show any data.
In OLAP you are able to define ragged hierarchies. In a ragged hierarchy, the logical parent member of at least one member is not in the level immediately above the member. This can cause branches of the hierarchy to descend to different levels. RadPivotGrid doesn't show them correctly.
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