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
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
------------------------------
------------------------------
Khalid Daoud
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendI'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
------------------------------
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
------------------------------- MarkShnier__YouI think to get a combined report to show the total arrivals and departures count at each Airport, you would need to have an automated process to create 2 child records of the main trip record.
If I were doing this I would make a formula URL button which would purge of the child table records and then run two saved table to table imports to create the children and then land the user on the summary report. So each time the report with one run it would basically purge and refresh all the children.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------