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------------------------------

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------------------------------

Thanks Mark, is it possible to take the results of multiple summary tables and combine them into a single table?------------------------------Mike Sanders------------------------------

If you mean that you have data and separate tables in an application then no it is very difficult to combine that information. Imagine if you had a spreadsheet with different tabs and each tab had completely different information in order to combine that becomes very tricky------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

All of the data is in one table. I need to sum one column (for 3 different milestone dates, depending on if they are empty or not) and then put those sums in a row for each of 5 cities. I want the result in this format: Market Date 1 Date 2 Date 3 Denver 17 16 4 Boston 0 0 0 Chicago 0 0 0 Dover 0 0 0 Evansville 0 0 0 TOTAL 17 16 4 I apologize for not explaining this very well.------------------------------Mike Sanders------------------------------

Let me see if I can respond by tation, because I'm on a bicycle now. Are you saying that each record has three different milestone dates on it and hence the very same record head and dad getting summarized into any of those three columns?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

New App | Qrew Discussions

12 Replies

MarkShnier__You
Qrew Legend
2 years ago
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
------------------------------
- MikeSanders
  Qrew Member
  2 years ago
  Thanks Mark!
  
  Mike
- MikeSanders
  Qrew Member
  2 years ago
  Thanks Mark, is it possible to take the results of multiple summary tables and combine them into a single table?
  
  ------------------------------
  Mike Sanders
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    2 years ago
    If you mean that you have data and separate tables in an application then no it is very difficult to combine that information.
    
    Imagine if you had a spreadsheet with different tabs and each tab had completely different information in order to combine that becomes very tricky
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

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

Forum Discussion

New App