nkolios

New to Charting

Discussion created by nkolios on Feb 22, 2012
Latest reply on Feb 29, 2012 by nkolios

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.

 

Thanks

Outcomes