In Dashboard Designer I have created a pivot chart based on data in a SharePoint list, using the Microsoft Data Retrieval Services to connect. My column name is something like Number of Allocated Items but this field is displayed in the chart legend as Sum of Number_0020_of_0020_Alloca. This is really annoying, especially since my data is already aggregated and having "Sum of" at the beginning is just dumb.
Can I change the display value of this field? I have not been able to find anything in the chart Commands and Options dialog box.
As a last resort, I attempted to edit the dsQuery string in the Data dialog box. The Data Retrieval Services is using a query against DspSts.asmx, which specifies that you can do something like this:
<Field Name="Ugly_0020_Name" Alias="Pretty Name" />
When I modify the connection string to include the Alias I get no data returned. Am I doing it wrong?