Hi Ian,
Thank you for your interest in syncfusion products.
Please refer to our dashboard sample to the following path. which acheives your desired behaviour.
{Installed Path}\Syncfusion\EssentialStudio\{Version}\Windows\Grid.Windows\Samples\2.0\MS Excel-Style Features\Grid Control Sort Demo
Please let me know if you have any further concerns.
Regards,
Ragamathullah B.