Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Do you mean Sum(Revenue)/Count(Client) or Sum(Client)
How would you calculate Sum(Client) here?
Sorry, .. I mean Sum(Revenue)/Count(Client) , grouped by Month independently of the year
Like this?