Hey,
I've made a little database to store sales figures and im trying to get a chart from it. Fields in the table are; the week (1-52), year and turnover.
Ideally id like a chart where the week is on the x asis, and the year is the series. However, im also trying to get it so that say it shows the last 8 weeks (but still has the previous years data for those 8 weeks next to it).
Im running into the prob of figuring out how to make the x asis go from week 52 (of 2009) to week 1 (of 2010). I tried combining the year into the week so that the order was correct but then I couldnt have the previous years data next to the current.
Perhaps ive done it wrong or its just too late in the night for me. Any help would be greatly appreciated as this is the last part for my little app
.
Thanks
I've made a little database to store sales figures and im trying to get a chart from it. Fields in the table are; the week (1-52), year and turnover.
Ideally id like a chart where the week is on the x asis, and the year is the series. However, im also trying to get it so that say it shows the last 8 weeks (but still has the previous years data for those 8 weeks next to it).
Im running into the prob of figuring out how to make the x asis go from week 52 (of 2009) to week 1 (of 2010). I tried combining the year into the week so that the order was correct but then I couldnt have the previous years data next to the current.
Perhaps ive done it wrong or its just too late in the night for me. Any help would be greatly appreciated as this is the last part for my little app
.Thanks
