Hi, I'm a bit new to charting in Filemaker. I have a table which contains a list of product sales showing volumes of sales only. The list is extensive and covers several years, the products are grouped together by type. I am trying to compare volume sales per month, so for one year I will have 12 bars, but also compare the years so each month could have several series representing the different years. At the moment they are altogether in one table and I wanted to know if there was anyway of producing this chart without have to break my data up.
I have added a field to each record which puts each record into a particular year and our financial year starts at the begining of October so i have also had to reshuffle the months by assiging a number to each month.
Any help would be appreciated.