I have created a crystal report for actual vs. budget using an union command with the FBDETAIL and GLAMOUNTS tables. I am able to calculate the quarter totals for both actual and budgets by Accounting Unit. The quarter totals are listed on the same line. I want to combine all of the quarters into one amount column by quarter with seperate columns for the actual and budget so I can create a graph by quarter showing both actual and budget.
Any suggestions on how to do this?