How to construct this table?
I have a table of Projects.
Each Project has the following fields (for this example, they can be checkbox fields)
Requested by/Submitted to Customer In Preparation Submitted to HNC Approved b...
Forum Discussion
Mark,
Won't that only work if each Project Record can fit neatly into a single category? If I simplify to the chart below (where number of SOs is simply ESO+RSO+.....), I will have the need for the same record to be counted in the Submitted row, AND the Approved row AND the Executed Row. At a certain point, projects actually fit into multiple categories simultaneously.
Where I am lost is - the original Summary Sort needs to be by SO Category right? But if I do that sort, won't it only be able to put the record into one of the categories?
------------------------------
Mike Tamoush
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legend:)
You missing the fact that by creating say four helper fields you can summarize four fields (as well as that numeric field) in the summarize what section.
The Summary report DOES NOT have column grouping, just row grouping.
Make the first two of those fields I suggested (or all 4 while you are at it) and you will see. You know tht in the section for
Summarize Data
you can add as many fields as you like to summarize and they become more columns. Just hover beside the first field you selected and you will get the opportunity to add I think an infinite number of more fields to summarize.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------