In your Demo select PivotGrid - OLAP Support
1. sort rows by "Reseller Order Quantity"
2. reopen sorting panel
-> another option will be selected
In the sorting options dialog, the selected column in the sorting options appears to be set to a wrong value upon reopening the dialog.
In your demo select PivotGrid - Olap Support
1. add "Exchange Rates: Average Rate" to values
2. sort rows by "Reseller Order Quantity"
-> The grid will be empty
If the list is filtered by "Total Reseller Order Quantity != 0", results will show again. Thus, sorting by a column which contains rows without values seems to be faulty.
Currently, the Telerik.Pivot.DataProviders.Adomd project relies on that the Microsoft.AnalysisServices.AdomdClient dll is installed in the GAC. The dll is installed with the ADOMD feature package that come with the SQL Server installation. If the required SQL Server feature is not installed on the machine, the Microsoft.AnalysisServices.AdomdClient.dll is missing from the GAC and the installation of the Telerik.Pivot.DataProviders.Adomd.for.Wpf package fails with an error. The error is:
Failed to add reference. The package 'Telerik.Pivot.DataProviders.Adomd.for.Wpf.Xaml' tried to add a framework reference to 'Microsoft.AnalysisServices.AdomdClient' which was not found in the GAC. This is possibly a bug in the package. Please contact the package owners for assistance.
Add a dependency to the Microsoft.AnalysisServices.AdomdClient package, instead of relying on the dll installed in the GAC.
Currently, you can use the FilterDescriptions of the Olap data providers (like AdomdDataProvider and XamlDataProvider) or the GroupFilter of the group descriptions.
Add an API that allows you to implement custom filtering behavior using a filtering function or constructing custom filtering expression.
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