In chart, I am getting the months in alphabetical order whereas the same is required as per calendar month.
I have written a query as under :
Select to_char(RA_CUSTOMER_TRX_ALL.trx_date, 'MON') invoice_month,
SUM RA_CUSTOMER_TRX_LINES_ALL.quantity_invoiced*RA_CUSTOMER_TRX_LINES_ALL.unit_selling_price) invoice_amount
FROM RA_CUSTOMER_TRX_ALL
FULL OUTER JOIN RA_CUSTOMER_TRX_LINES_ALL
ON RA_CUSTOMER_TRX_ALL.customer_trx_id=RA_CUSTOMER_TRX_LINES_ALL.customer_trx_id
WHERE RA_CUSTOMER_TRX_ALL.trx_date BETWEEN '01-APR-2008' AND '31-MAR-2009'
GROUP BY to_char(RA_CUSTOMER_TRX_ALL.trx_date, 'MON')
Please advise