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): •
Currency (leading dollar sign) •
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.
Recently Asked Questions
- how do I write a report about analyzing my own progress in Maslow hierarchy of needs. ( need to look at my life, past and present, and decide what stages/
- 1- Draw a fully labelled diagram to show the long-run equilibrium position using the AD curve, the SRAS curve and the LRAS curve. Explain any FOUR (4) factors
- Which of the following scenarios depicts an analogue behavioral observation ?