MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pivot table

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?


Posted by Kiah on June 06, 2001 8:49 PM

Not exactly sure how your pivot is set up but you could try this.
Right click on the data field, left click on field settings, PivotTable Field left click on the options button, in the show data as window change it to % of row or which ever selection will do what you need.

Hope that helps.

Posted by Mark W. on June 07, 2001 7:01 AM

Your data doesn't compute!

Do you have 10 or 9 passengers? Does you data
include a column for passenger count or does
your data look like this...


If your data looks like that listed above...

1. Drag 'City' to your PivotTable's ROW area.
2. Drag 'Class' to your PivotTable's COLUMN area.
3. Drag 'City' to DATA area.
4. Double-click the 'City' field in the DATA area,
and change it's Name to "Count of Passengers".
5. Next, press the [ Options >> ] button,
change the "Show data as" field to "% of row",
and press [ OK ].
6. Finally, press [ Finish ] on the Step 3 of 4
PivotTable Wizard dialog.

Is this what you want?

Posted by lars How do I make additional comments? on June 07, 2001 4:33 PM

Re: Your data doesn't compute!

Posted by lars Thanks How do I not show blank info? on June 07, 2001 4:38 PM

Posted by Mark W. on June 08, 2001 7:28 AM

Enter your comments & press [ Submit Follow Up ]