RE: Sharepoint 2010 Quest Web part count and sort by totals

[Anonymous]

Hi Bill,

  qChartview web part allows you to sort on list columns only.

To build such a formula take a look here

http://msdn.microsoft.com/en-us/library/bb862071.aspx

and here

http://sharepoint.stackexchange.com/questions/29140/using-calculated-field-to-retrieve-substring-of-another-field

The idea is to use the function LEFT, return the most left chars before the space (possibly convert it to a number although is not necessary because of the format (07, 23, 38, etc)) into a column and then use it for sorting.

I hope this helps.

,