Odp: aggregation question

Petr,

Maybe I did not make it clear, I apologize for that:

I want January to December on the X Axis (as 12 discrete (months))
and then for each month the values for each year as bars in
different colors next to each other, ie Jan-2009, Jan-2011,
Jan-2011...Dec-2009, Dec-2011, Dec-2011 whereas at the moment I get
Jan-2009, Feb-2009, Mar-2009...Oct-2011, Nov-2011, Dec-2011

In SQL something like GROUP BY MONTH, YEAR as opposed to GROUP BY
YEAR, MONTH.

greetings, el

on 2011-07-07 11:08 Petr PIKAL said the following:
[...]

How do I get the monthly aggregated payments in different colors
next to each other (ie for each year in a different color with the x
axis showing the months)?

What about putting suitable set of colours to col argument?

Regards
Petr

[...]

Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el at lisse.NA el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way