I need help on a graph, I have searched and have found some solutions that average sales per month but I needed something different. I have a date field this field is called procedure_date, ie the day a procedure was done. There are several procedures I do, but we can use fruits as an example, there are apples, oranges, bananas, grapes... When charting I want to break down over several months Jan/Feb/March how many apples vs oranges vs bananas where sold (or in procedure terms done). I am only able to get a total count of all the procedures done in a month,. The graph I need would have on the x axis the month, with 4 bars one for each fruit (procedure) for each month so Jan 4 bars, feb 4 bars comparing how many of each where done per month. I now have a variable called cMonth which grouped individual dates into months, but I don't know how to now use cMonth and get a chart as described above.
Any help or pointer would be appreciated