View the step-by-step solution to:

What do the instructions below want me to do?

What do the instructions below want me to do? I can make a pivot table, but there is no grand total. Section F say that row and column calculations (sum) are required so that te total revenue for each location and he total revenue for each car class are visible in the pivot table. There must be a grand total that represents the sum of all revenue.

It is not showing me a grand total. It says "Grand Total" but there are no numbers. What is the sum that is required an where is this data summed from?

Also, how do I upload the document to you so that you have the context?

Step Requirement Comments 11 In the Initial Analysis worksheet, using the Excel table just copied there:

a. Create a Pivot Table.

b. Adjust column widths if necessary to eliminate title and data truncation of the pivot table.

c. Locate the top edge of the Pivot Table in at the top edge of Row 1 and a few columns to the right of the data

d. Display the total revenue for all four types (carclass) of vehicles.

e. Display the total revenue for both Airport and Downtown locations.

f. Row and column calculations (sum) are required so that the total revenue for EACH location and the total revenue for EACH carclass are visible in the pivot table. There must be a grand total that represents the sum of ALL revenue.

g. Ensure that the formatting is as listed in the Comments column. Format (for pivot table label, text, data as appropriate): •

No decimal places •

Arial 10 point •

Normal font •

No title or data truncation in the pivot table. •

Right-align the row labels.

12 In the Initial Analysis worksheet, using the pivot table:

a. Create a column or bar type of chart that shows the total revenue for each of the four vehicle types at each location.

b. Add a title that reflects the information presented by the chart.

c. The upper left corner of the chart should be one or two rows below the above referenced pivot table and left-aligned with the pivot table.

d. The chart should clearly indicate location and type of car. The chart should allow a viewer to determine approximate revenue totals for each vehicle total revenue at each location. The chart should have no more than 8 bars or columns.

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
• -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents