I want to display sales data by month from the current year and the previous year on the same chart. I've created two data sets, each of which has [month] as one of it's members. I set up the chart with two different Values members: Current &
Previous and one Category group: Month. The current year data displays as expected but the previous year just shows as a straight line across the chart.
Can I get both sets of data to display on the same chart?
I tried building a single query that would return a single dataset with two values, one for current year/month sales and another for previous year/month sales but my MDX isn't that good so I ended up with different queries.
View Complete Post