Summary report for multiple fields
Is it possible to summarize the values of two fields in a summary report? I've got these two fields "Origin Airport Code" & "Destination Airport Code" that I'd like to summarize in one report. ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou can set the row grouping by Origin and the column grouping by Destination. You can then should a record count in the grid.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Thanks Mark - I already tried that. Is there a way to combine the values of the two fields in one field (maybe using a formula)? Then use that field in the summary report.
------------------------------
Khalid Daoud
------------------------------- MarkShnier__YouI'm not really understanding the visualization of the look you want, but you can choose to summarize more than one value, if that is helpful.
Maybe post an excel sheet with an example of your data and the look you want.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Well, my ultimate goal is to summarize the number of times a particular airport is used. That goes for both departures and arrivals into that particular airport. Right now I have two separate summary reports (see attached). I would like to have one report (Airports) that combines the values of both fields.
------------------------------
Khalid Daoud
------------------------------
