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 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.
Similar to Excel - RadPivotGrid could have an area, where you can select some filter/group descriptions.
Currently, the string format (used in the cells generated for the from the DateTimeGroupDescription) is determined automatically based on the selected Step (Day, Month, etc.). Add an option to easily set custom string format.
At this moment, you can change the format only if you create a custom description and override a considerable amount of code. This is shown in the following SDK example: https://github.com/telerik/xaml-sdk/tree/master/PivotGrid/CustomDateTimeGroupDescription
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.
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