I am trying to create a bar graph that shows total amount of Quotes per month from jan 2010 to september 2010 my script looks like this at the moment
Month(ih_quodate) as [Quote Month],Text(ih_quotat) as [Quote No]; LOAD * WHERE Year([ih_quodate]) = 2010
My Bar graph seems to display coreectly and shows the correct amount of quotes for Jan but then seems to add up Febs quotes with January Quotes and the same with the rest of the months.
So January would be say 112 and febuary should be 210 but it show Februarys as 322 instead, it does this for all the other months just adding them together.
Is it possible to prevent this.?