HI,
I have users that would like to sort the rows for Seller Name as in the screen shot. Is this possible?
Hello Kevin,
It is possible to sort the rows that you have shown in your screenshot by using an OrderByKeyExpression in your HierarchyDescriptor for your FlatDataSource. We have documentation that demonstrates how you can do this here: https://ko.infragistics.com/help/wpf/xampivotgrid-sorting-rows-and-columns.
Please note that with the FlatDataSource, in order for sorts to take effect, you will need to set the PreserveMembersOrder property of the data source to “false.” Without this setting, the rows and columns will always show in the order they appear in the data source.
Please let me know if you have any other questions or concerns on this matter.
That's great, thank you Andrew. The missing bit of the puzzle was the PreserveMembersOrder property.
Is there a way of customizing the template for the header cell highlighted below? I'd like to put a button in there that the user can click on to sort by seller name.