I need to build a line chart with the following series.

• Last year sales
• Current year sales
• Current year Budget
• Current year ForeCast

The bottom axis should simply the twelve calendar months. 

Also the line should rise by aggregating each months sales.

This should be simple but I cant get it right. And I dont know if its the cube that has bad content, me dont understanding the cube content or if I must use custuom MDX queries. 

To begin with, is it possible withiuth MDX?

And second, is it possible with MDX?

• Edited by Tim Scharinger Tuesday, June 25, 2013 11:47 AM

You should be able to come close to this design as long as the items exist in your SSAS cube that you are referencing.

On the bottom axis you would place your Month Names (Jan - Dec).

For the series you would put the years that you want to look at and you can setup a connection to a filter to allow a user to change this.

Then you just need to put your measures on their for sales, budget, and forecast amounts.

It would kind of look like this trend chart in the lower left-hand corner of this image - http://denglishbi.files.wordpress.com/2012/02/image14.png

HTH

Hi Dan,

How do you sort the bottom axis by month names?

Cheers

You define the order by in the properties of the month name attribute.  Typically you would have another column called Month Number that would be the values 1 through 12 and you would use that to either be the key column of Month Name or you would relate it to the Month Name so that you could order by that attribute.

Sort Order of Bottom Axis in Chart http://social.technet.microsoft.com/Forums/en-US/5beecb36-f7d4-49a1-a9d7-746af2adfa0b/sort-order-of-bottom-axis-in-chart#4a30d110-ab1a-4db3-8a9b-25735378608b