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.
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.