How To Create A Top 10 + Other Pie Chart

Hi All,

I'm trying to figure out, how to create a Top 10 + Others pie chart. Well, I think I wouldn't have the problem if I could write a SQL statement... but I my data source is from SharePoint list like:

<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
<Parameters>
<Parameter Name="listName">
<DefaultValue>{4FDB998D-31CF-4988-883D-1187ECD12574}</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>

Could someone give me a hint how to do it?

Many thanks in advance.

Nearshore