bandellwork Posted February 27, 2012 Share Posted February 27, 2012 I am working on a school project and need a little help. A little background of what I am trying to do. I have a query that brings back sales totals for each month of a year for products, services, and maintance. so the results look like the following.Month Sales ProdOrSalesJan 10000 ServicesJan 2500 ProductsJan 1000 MaintanceFeb 9000 ServicesFeb 3000 ProductsFeb 1500 Maintanceand so on for each monthI am trying to create a multi axis chart that includes a line graph and a bar graph. The line graph works the way I want it to. Each category has it's own line (Services, Products, Maintance). I am having problems with the bar graph. I want the bar graph to total all three categories for each month. However it only goes up to the category that has the highest amount. Any ideas on how I can sum the totals for the month. Thanks for any help. Link to comment Share on other sites More sharing options...
bandellwork Posted February 28, 2012 Author Share Posted February 28, 2012 Update. I used the sum Sales_Sum automatically generate by iReports. The problem now is that it keeps a running sum from month to month. So Jan the bar would be 13500 Feb 27000 and so on. Is there a way to reset sum to 0 for each month? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now