CRM 2011 – Error changing Sales Pipeline Funnel Chart

I tried to adjust the Sales pipeline chart today to use a different value to funnel because I was currently getting one big blue funnel.  I would say before I go that this might be fixed in CRM rollup 5 upwards because they did improve the functionality of the graphs.


I tried to change the field from Pipeline phase to Process Code but then when you try and save the report the error below appears

I found the answer to the problem on a forum

basically you need to export the chart, open the xml and change the variable stepname into

You just need to replace “stepname” with the name of your custom field. For example, if your field is called new_salesstage, the order element would look like this:

<order alias=”stepname ” descending=”false” />

To (or whatever the name of your field is)

<order alias=”salesstagecode ” descending=”false” />


You should

and finally you should see the fixed pipeline












Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s