Even a few years into Developing, I still sometimes can't visual how to summarize my data in reports. Can I accomplish the following with a Summary Report, or do I need a summary table?
I have a table of Monthly Financial Reports. Each month for each project a report is created. The fields on these reports include:
Revenue
Projected Costs
Projected Gross Margin
Project GM %
Date of report
I want to create a summary report that looks as follows, but just cant seem to figure it out. Can't sort out what my summary fields are, etc to make it appear in this format. I do not think I will need to take advantage of the summary report formulas as there will only be one per month so I don't need to worry about recreating the GM% or anything (ill eventually filter by project number, this will be used in a report link):
Jan Feb Mar Apr May June .....
Revenue
Projected Costs (Totals here in each row and column)
Projected GM
Projected GM %
------------------------------
Mike Tamoush
------------------------------
Question
Summary Report Question
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.