I am creating a Line chart from a table. The table includes a code column, date column, and several statistic columns. The dates are end of month dates only. There are about 10 different codes for each month. The statisic columns are the totals for the month for each code.
PeriodEndDate Code Statistic1 Statistic2 Statistic3 Statistic4
XX/XX/XXXX XX 999 999 999 999
On my line chart I want to show one or more statistics for one year for a given code. (A line for each statistic)
On a different report I want to show one or more codes for one year for a given statistic. (A line for each code)
The report has parameters for the code and the statistic. I have figured out how to create the chart for one code for one year for a given statistic. Can any one help me out?