Hello
I did not found this functionality in any of your samples or in the documentation or in the code itself. Is there any feature to let the user sort the "rows"?
Please see attached image. (I want to sort the red marked rows...)
Kind regards
Fyi,
If for some reason sorting rows is not taking affect when using the FlatDataSource you'll need to set the PreserveMembersOrder property to False for the order by key expression to take affect. Please review my sample attached below.
Hi PV85281,
You can perform that kind of sorting with FlatDataSources as I have stated in my previous post. The first link I provided contains information on how to do that. The reason that type of sorting can be done with the FlatDataSource and not the other types is because the other types get their hierarchy information from the database. FlatDataSource has to create the hierarchies itself. This means you can provide your own hierarchy where the sorting logic is provided through the OrderByExpression. The other data source types do not have this capability.
If you wish to see this capability present in other data sources, I recommend that you submit this as a new product idea here.
Hi Rob
We are using FlatDataSources and AdomdDataSources. And the sorting thru column header is already activated.
But our users need to have the possibility to sort the rows like shown in the picture. We don't want to sort it in the database before, the user should have the possibility to sort it the way he wants... so this feature is still not available in the current version 2014 Vol2? Do you plan to implent this sorting possibility?
Hello PV85281,
If you are using a FlatDataSource, you can filter the rows using the following documentation: http://help.infragistics.com/doc/WPF/2014.2/CLR4.0/?page=xamPivotGrid_Sorting_Rows_and_Columns.html
However, if you are using XmlaDataSource or any other data source, the only kind of sorting available is through the column headers. http://help.infragistics.com/Help/Doc/WPF/2014.2/CLR4.0/html/xamPivotGrid_US_Sorting_Data.html
I believe sorting the rows like that will require that the dimensions already be sorted in the database.