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
------------------------------
So if those helper fields go in Summarize Data, what goes in the grouping and cross tabs? Do I need 7 more helper fields, for all the possible Categories?
To the best of my knowledge, the row grouping would need to be SO Category. Except, doesn't that assume each project is currently in a single SO Category?
In my case, a single project is simultaneously in multiple categories. In fact, there is no single 'SO Category Field'. A single project may have been Submitted AND Approved AND Executed, and needs to be counted on each row.
Am I missing something obvious?
------------------------------
Mike Tamoush
------------------------------- MarkShnier__You
Now, I am getting confused about your question. You will not use column groupings at all. Make those four helper fields include them in the summarize list of fields to be summarized and just group it by the roes you exactly showed in that example that you wanted.
Is there some different result you want other than what you put in the picture on your original post?
I am thinking that you are overthinking this. Just make those four fields and try it. Let me know what doesn't work after you do that.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------The crux of the issue is I put in your 4 helper fields, but I have no idea what to put here:
So in answer to your question about what doesn't work....I cant even save the summary report because I have nothing to put in that spot. There is no 'SO Category' Field. There can't be a single SO Category field.
I think the issue is, I am stuck on is a different one than you are solving. My main question is - how do I develop the rows, knowing that a single project fits simultaneously into multiple rows?
------------------------------
Mike Tamoush
------------------------------