Group by Month

[#1]

Hi Folks,

I have a data containing

Month	Year	Revenue	Client
1	2010	12	A
1	2011	13	B
2	2010	14	B
2	2011	15	B

And I want a chart like this:

YValue =  Sum(Revenue) / Sum(Client)

XValue = Month of the Year

How can I by Month number ?

[sunny_talwar]

Do you mean Sum(Revenue)/Count(Client)  or Sum(Client)

How would you calculate Sum(Client) here?

[#3]

Sorry, ..    I mean Sum(Revenue)/Count(Client) , grouped by Month independently of the year

[sunny_talwar]

Like this?