troubleshooting Question

Graph - How Do I???

Avatar of Clif
ClifFlag for United States of America asked on
Crystal Reports
9 Comments1 Solution286 ViewsLast Modified:
I need a graph similar to this:
ExampleObviously there are eight columns, two for each quarter.  Each of the two columns for each quarter represents two years (2011 and 2012).  Each column represents two values, Income (yellow) and Expense (Cyan)

In the Chart Expert, I select 'For each record' to be year and 'Show Values' of Income and Expense.

I can get a single set of two columns (any particular quarter), but how do I get all quarters to show up as in the example graph?

My query currently returns Year, Value Type (I = income, E = expense) and the values for each month which I calculate to give me the values per quarter.  So, I might have two records that return values such as this:
Year   Type   January   February   March     April
2011     I    600000    650000     500000    450000
2012     I    800000	900000     550000    600000
2011     E    800000	900000     900000    1000000
2012     E    900000	1000000    14000000  1000000
(Only showing to April 'cause I got tired of typing, but you get the idea)

I can modify the query if needed.

Hopefully I got my needs across.  :)

TIA
ASKER CERTIFIED SOLUTION
James0628

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros