You cannot sort the aggregates as they are only values in cells. However you can sort the Group Descritptions (in rows and columns) based on the values in the cells. You just have to use GrandTotalComparer
as shown in this article
Hope this helps.
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos
and start improving your app based on facts, not hunches.