Weird Combo Chart Display
16 October, 2015
I am trying to create an overlay chart. I have 3 values. New which indicate new customer, terminate, which indicate customer who has stopped and net target, which is the no of new customer expected by management.
I created a 2 union sub-query. The struggle I had was initial with the dates. Using date hierarchy month template.The data were not arranged in the correct order. Since the requirement is to show the performance from April , January is meant to be in the following year. I used resorted to using date formatted in MMM,yy format, The data did not group up nicely in the crosstab report.
However, what I am concern about is why, for NET TARGET, the chart onlu pickup from September. The screen shot attached shows data for every month since April to Sept 2015.
Any idea?


[img][/img]
Thank you for letting us know that you have been able to resolve your issue.
If you do have any further questions please feel free to contact us.
Thanks
Adam