New App
I would appreciate any suggestions on the best way to set up a new app to be able to create this simple table:
Each market has multiple records which have any number of items in the 3 categories. The different item types are summed to give the number shown above.
It seems like a simple table, but I haven't been able to figure it out. Please help!
------------------------------
Mike Sanders
------------------------------
| Market | Total Items | MS 2 Items | MS 3 Items |
| Houston | 17 | 16 | 4 |
| Indianapolis | 22 | 0 | 0 |
| Atlanta | 13 | 7 | 6 |
| Miami | 0 | 0 | 0 |
| Los Angeles | 0 | 8 | 10 |
| TOTAL | 52 | 31 | 20 |
Each market has multiple records which have any number of items in the 3 categories. The different item types are summed to give the number shown above.
It seems like a simple table, but I haven't been able to figure it out. Please help!
------------------------------
Mike Sanders
------------------------------
- The items table should just have three fields for:
- Market (multiple choice or lookup from a relationship) ,
- Qty
- Type (multiple choice if there are just a few choices).
The config for the summary report is that group by Rows are Market and "group columns" by type.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
