Summary Report
I think I am missing something obvious with a summary report I am trying to build. I have a lot of projects. Some projects have been submitted, some have been approved, some have been canceled, some h...
Forum Discussion
But even so, then don't I have to Group by one, THEN by another, THEN by another? Or do I use them in the summary section, and if so, how do I incorporate the total cost?
------------------------------
Mike Tamoush
------------------------------
------------------------------
Mike Tamoush
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendA summary report will allow you to have multiple fields for the summarize what. That will be separate from the group by.
I think in your case this will be a one line report and you will need a dummy field to summarize on, like a field that calculates to the word "ALL".
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I think in your case this will be a one line report and you will need a dummy field to summarize on, like a field that calculates to the word "ALL".
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- That mostly works, and I can get all my items as wanted up top as summary columns, but I cant come up with a trick to see my total costs for each one of those columns.
------------------------------
Mike Tamoush
------------------------------- MarkShnier__YouWell its the same story, you will need to have 3 more fields on the record.
But Plan B is If you really want to lay out the information on a "square" type layout, you would need to create a helper table with just 1 record in it and summarize the totals up to that record.
Then you could lay them out on a form nicely.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Ahh. Summary table is probably the way to go. Just wanted to make sure I wasn't missing something obvious with summary reports. Thanks!
------------------------------
Mike Tamoush
------------------------------