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