I would appreciate any suggestions on the best way to set up a new app to be able to create this simple table:
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 ------------------------------
Best answer by MarkShnierYou
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).
Then use a summary report to make your report.
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 ------------------------------
