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
You need to end up with a single Measure data item, then create an additional data item to describe the measure (Total Sale, Total Budget, ...). What you could do is union a bunch of queries together, each one must have an identifier to describe the measure it is fetching. Then you could use the Identifier as a series.