Posted by Lars on June 06, 2001 5:14 PM
Please help..if you do I might even get you a cheap cruise. I have data that is summarized down to three levels. The first is air city and within each air city is the carrier and within each carrier is the class of service. All of this relates to passengers.
I want to count he number of passengers at the class of service level. For example 5 people flew in "A" class for Amercian Airlines from LAX. 4 people flew in "B" class on Contental from LAX. That is a total of 10 people that flew from LAX and the pivot table sums that below. Can I calculate the percentage of people that flew in "A" class and "B" class from the total of LAX. In other words "A class is 50% of the 10 people that flew from LAX and "B" class is 50% totaling 100%. Is this possible?