Available in LIB version 2016.2.606, it will be also available in the 2016 R2 SP1 release.
Currently it is only possible to either show all or hide all subtotals.
The DistinctValuesLimit property is available in our R1 2018 Release.
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.
Currently the header of that column says "Grand Total" instead of the aggregate name.
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 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.
As a user I would like QueryableDataProvider to avoid blocking the UI while executing the query on the database server.
When a filter dialog is shown (Report Filter or Label Filter) for OLAP Hierarchy, it contains the items only for the selected level. Instead items from all levels could be visible, so you won't have to open additional dialogs to filter them (show them like a tree).