Originally Posted by
flyerbjorn
I'd create another pivot tab and deduct the us-based / international information from the home airport name. There's got to be some easy way to do that. Happy to help if you can't find it.
Sure I can do this. Just want to make sure I understand. Sounds like you want another variable that denotes whether a person's home airport is US vs International?? And then to have separate charts comparing domestic vs international qualification metrics? Is this correct?
Note that of the approx 250 responses, only 4 were international. So it might be difficult to draw conclusions from such a small sample size:
1 MUC
1 PEK
1 SYD
1 DEN/MEL