Hello,
I'm trying to create a line chart based on monthly sales over the past year. But the graph doesn't match the crosstab query it's based on. So even though the query reads:
But instead the graph comes out as if the query reads
So basically, it reads the record from Jun-13 - Dec-13 as Jun-14 - Dec-14, and goes in order from Jan-14 - Dec-14, instead of Jun-13 - May-14. I hope this makes sense!
I'm trying to create a line chart based on monthly sales over the past year. But the graph doesn't match the crosstab query it's based on. So even though the query reads:
Code:
month sales
jun-13 $1000
jul-13 $2000
aug-13 $3000
...
jan-14 $4000
...
apr-14 $5000
may-14 $6000
But instead the graph comes out as if the query reads
Code:
month sales
jan-14 $4000
...
apr-14 $5000
may-14 $6000
jun-14 $1000
jul-14 $2000
aug-14 $3000
So basically, it reads the record from Jun-13 - Dec-13 as Jun-14 - Dec-14, and goes in order from Jan-14 - Dec-14, instead of Jun-13 - May-14. I hope this makes sense!