N:N Relationship Charts in MS Dynamics CRM

N:N Relationships, or Many-to-Many Relationships, can be a little tricky to get information out of. As an example competitors out-of-the-box have an N:N relationship with opportunities. Let's say we wanted to look at a list of competitors and see how many active opportunities they are currently engaged in. With the chart editor and views, the … Continue reading N:N Relationship Charts in MS Dynamics CRM

Add Percentage Labels to a 100% Stacked Bar chart in MS Dynamics CRM

The 100% stacked bar chart is great to display the relative amounts within a series. However, for some reason the 100% stacked bar chart comes without labels to indicate what the percentage is for each group. You can eyeball it, but that's not very accurate. It is a little tricky to get to the accurate … Continue reading Add Percentage Labels to a 100% Stacked Bar chart in MS Dynamics CRM

Aggregate Total on top of Stacked Column Charts or Bar Charts in MS CRM 2011

Adding an aggregated total to the top of a stacked column chart sounds simple enough. It’s a couple of clicks in Excel. In MS CRM 2011 however, it is a different story. You would have to add an additional series to the chart, which then calculates and displays the total. But Stacked Column charts in … Continue reading Aggregate Total on top of Stacked Column Charts or Bar Charts in MS CRM 2011