Hi All,
i have following data to create report
1.13 month rolling data item - for history suppose from May06 to May07
2.Forward Bgt month data - advance 6 month - suppose from jun07 to Dec07
3.I have region like Asia,Emea,India etc
4.I have measure like total sale,total budget
Now i want to create a chart (combination) in such a way.In one line show both Measure data for Asia region with difference Solid and Dash line for Rolling month and Forwrd month..i mean once Rolling month finish it shud contine same line with dash line for Asia...so there wil be only 3 lines for 3 region.To make difference the line wil be solid and dash for Rolling and Forwrd..
Is anyone have any idea or any thought how we can achieve ?
thanks n advance