Using Pivot Tables

In: Computers and Technology

Submitted By emilyyan
Words 398
Pages 2
Total sales by month by Make
Sum of Price | Column Labels | | | |
Row Labels | Jan | Feb | Mar | Grand Total |
BMW | 43800 | 34499 | 142340 | 220639 |
Ford | 92361 | 12680 | 25220 | 130261 |
GMH | 12400 | 18900 | 22800 | 54100 |
Hyundai | 34500 | | | 34500 |
KIA | 12800 | 10500 | 19700 | 43000 |
Mitsubishi | 3500 | 8600 | 30700 | 42800 |
Nissan | | 27600 | 100020 | 127620 |
Peugot | 12400 | 19900 | 8532 | 40832 |
Renault | 21090 | 30599 | 5600 | 57289 |
Toyota | 41855 | 22100 | 43489 | 107444 |
Volkswagen | 45700 | 17900 | 70122 | 133722 |
Grand Total | 320406 | 203278 | 468523 | 992207 |

Difference in total sales from previous month by Make
Sum of Price | Column Labels | | | |
Row Labels | Jan | Feb | Mar | Grand Total |
BMW | | -9301 | 107841 | |
Ford | | -79681 | 12540 | |
GMH | | 6500 | 3900 | |
Hyundai | | -34500 | 0 | |
KIA | | -2300 | 9200 | |
Mitsubishi | | 5100 | 22100 | |
Nissan | | 27600 | 72420 | |
Peugot | | 7500 | -11368 | |
Renault | | 9509 | -24999 | |
Toyota | | -19755 | 21389 | |
Volkswagen | | -27800 | 52222 | |
Grand Total | | -117128 | 265245 | |

Chart of total sales for each region each month, showing amount of sales by each salesperson

Total sales and total commission earned (at 5%) for each salesperson, by month
Row Labels | Sum of Price | Sum of commission |
Jan | 320406 | 16,020 |
Hector Smith | 109355 | 5,468 |
Justin Callaghan | 44020 | 2,201 |
Mary O'Dwyer | 167031 | 8,352 |
Feb | 203278 | 10,164 |
Hector Smith | 61358 | 3,068 |
Justin Callaghan | 21080 | 1,054 |
Mary O'Dwyer | 120840 | 6,042…...

Similar Documents

Periodic Table

.... Mendeleev was not the first chemist to do so, but he was the first to be recognized as using the trends in his periodic table to predict the properties of those missing elements, such as gallium and germanium. The second decision was to occasionally ignore the order suggested by the atomic weights and switch adjacent elements, such as cobalt and nickel, to better classify them into chemical families. With the development of theories of atomic structure, it became apparent that Mendeleev had listed the elements in order of increasing atomic number or nuclear charge. Further development In the years following publication of Mendeleev's periodic table, the gaps he identified were filled as chemists discovered additional naturally occurring elements. It is often stated that the last naturally occurring element to be discovered was francium (referred to by Mendeleev as eka-caesium) in 1939.However, plutonium, produced synthetically in 1940, was identified in trace quantities as a naturally occurring primordial element in 1971, and in 2011 it was found that all the elements up to californium can occur naturally in trace amounts in uranium ores by neutron capture and beta decay. With the development of modern quantum mechanical theories of electron configurations within atoms, it became apparent that each period (row) in the table corresponded to the filling of a quantum shell of electrons. Larger atoms have more electron sub-shells, so modern tables have progressively longer......

Words: 2708 - Pages: 11

Table Tennis

... ball, hand him/her another ball and continue the count. c. Forehand Volley Athlete stands on his/her side of the table with another player (feeder) on the other side. Using a total of five balls, the feeder tosses each ball to the athlete’s forehand side. The athlete scores one point for hitting the ball back to the feeder’s side of the table. The ball must hit the table to count as a point. The athlete scores five points for hitting into either service box. d. Backhand Volley Same as forehand volley, except the feeder sends the ball to the athlete’s backhand side. e. Serve The athlete shall serve five balls from the right side of the table and five balls from the left side of the table. A ball that lands in the correct service box will count as one point. f. Final Score A player’s final score is determined by adding together the scores achieved in each of the five events which comprise the Individual Skills Contest. 4. Unified Sports Doubles and Mixed Doubles a) Each Unified Sports doubles team shall consist of one athlete and one partner. b) Each team shall determine its own order of service. 5. Target Serve The athlete shall serve five balls from the right side of the table and five balls from the left side of the table. A ball that lands in the correct service box will count as one point. 6. Racket Bounce a. Using the racket, the athlete attempts to hit the ball upwards into the air as many times as possible during a 30-second time limit. b. If the...

Words: 4103 - Pages: 17

Motivation Table

...University of Phoenix Material Motivation Concepts Table Use the following table to complete the Motivation Concept Table assignment for Week One. You are encouraged to modify table formatting to suit your needs. Please consult with course instructor for additional assignment specifications. The completed table will serve as a resource for the remainder of the course. | | |Time Period Created | | |Theory Name |Major Theorist(s) | |Key Theory Concepts | |Will: |Descartes |1637 |Will motivates all actions. | | | | | | | | | |Will is an initiated and directed action. | | |Ruckmick |1936 |Striving to create impulses to act. Ruckmick | | | | |identified striving as an act of will in 1936.| | | | |The ability to resist self-denial or...

Words: 436 - Pages: 2

Table Manner

... impolite. -As a general rule the youngest person at the table has a few extra responsibilities. He or she is in charge of distributing the bowls, utensils  and napkins. If the bowls have a little water or dirt in them, as the youngest at the table, please kindly wipe it away. When you eat: - Firstly, you must take your food into your bowl, after that you can eat; do not take the food from the dishes and put it directly into your mouth. -Pass dishes with both hands. -Creat loud noise while eating and drinking, sometimes you can talk to pay them a compliment about the food, but remember you must talk after you swallow. - When you want to sneeze or cough, you must turn your back and cover your mouth. -You should not take the biggest or the most delicious food in the dish, or the seasons. -Playing with the chopsticks is unacceptable. If you drop one or both on the ground, pick them up and give them to someone, and take a new pair. Finally, chopsticks should never be placed sticking straight up in a bowl of rice. Chopsticks should be placed on the table or a chopstick rest after every few mouthfuls or when breaking to drink or speak. -When you have not decided what you want to eat, do not grab your chopsticks and then think. Please think before you grab your chopsticks. - When you eat soup, it is polite if you use common spoon to get the soup, you must be sure that you do not use your spoon to get the soup from the common dishes or bowls. - When you want to pick up......

Words: 1196 - Pages: 5

Open Table

... subscriptions from high-end restaurants. Using the four ways to market (e-commerce, useful, user-friendly technology, and hands-on techniques) worked well and they continued to grow. Then when Jeffrey Jordon, former president of PayPal, took over as CEO in 2007, he took a more aggressive approach with an initial public offering (IPO) despite the bad economy. It worked, and shares climbed 59% on the first day of trading. In just two years it had more than doubled from $20 a share to the mid-40s. 4. Why would restaurants find the software-as-a-service model very attractive? With the software being to use, staff members have realized that it helps them manage their business better. The system helps to fill additional seats, and helps to improve service excellence, providing a tangible return on investment. This has all led to higher customer satisfaction and higher retention rates....

Words: 373 - Pages: 2

E Table

...Touch Screen Restaurant Menus Increase Dining Experience Ordering food in a restaurant via iPad is so 2010. Think beyond the iPad. Imagine a future without waiters, without anyone asking you if you want sparkling or still. Without the condescending glance of a server who thinks they know so much. Imagine sitting down to dinner at a table lit by an overhead projector and interacting with the projections on the table in front of us. Our order? Placed by the swipe of a finger. This is the future of restaurants. These types of table first introduce London’s “inamo” restaurant called E-Table, the interactive ordering system is designed to give patrons “more control over their dining experience”.  A projector, which is installed in the ceiling above each table, projects an interactive menu on the tabletop.  Using a touch mouse pad, patrons can navigate the menu, place orders, choose a virtual tablecloth, and project images of each meal on their plates to help them decide which one to get.  The system isn’t only for placing orders – patrons can also use it to play video games, call a taxi, or watch the chef prepare their meals via a live webcam!  E-Table also offers a lot of perks to the restaurant owners, like reduced staff costs, an increase in customer spending, and a more efficient way to deal with customers. How it works: The E-Table system uses overhead projection to deliver a menu and other digital images to a restaurant table-top. Projected images do overlay food......

Words: 359 - Pages: 2

Comparision Table

...Summary Comparison table of dairy ingredients: Fromage frais (Strawberry, Vanilla and Natural) Double Cream and Plain yoghurt Sample | Image | Texture analysis | 1.Fruit puree 30gGelatine (dissolved)30gAfter it is been set mixed with strawberry formage frais 30g | | Nice colour, flavour been rated as OK, texture is not like jelly | 2.Fruit puree 30 gStrawberry fromage frais 30g Gelatine (dissolved)50g | | Not firm set, flavour is there, needs more gelatine, Fromage frais bring pleasant creamy taste, pale colour | 3.Fruit puree 40gStrawberry fromage frais 30gGelatine(dissolved) 40g | | Runny texture, didn’t set well, flavour is there, Fromage frais bring pleasant creamy taste, pale colour | 4.Fruit puree 40gGelatine (dissolved)40gAfter it is been set mixed with plain yoghurt 40g | | Strong overpowering taste of yoghurt, taste a bit sharp, pale colour, texture is not like jelly | 5.Fruit puree 30gGelatine (dissolved)30gPlain yoghurt 50g | | Texture is more like a jelly, but still strong yoghurt taste, pale colour | 6.Fruit puree 30gWhipped cream 30gGelatine(dissolved) 50g | | Pale colour, texture is more like mousse than jelly, whipped cream gives a strong overpowering taste, aftertaste strong creamy, fruit flavour is lost | 7.Fruit puree 30gDouble cream30gGelatine(dissolved) 50g | | Firm set, too strong overpowering cream taste, lost the fruit in the whole composition, pale colour | 8.Fruit puree 10gAgar(dissolved)15gStrawberry fromage frais 5g | | Nice...

Words: 456 - Pages: 2

Round Table

...Round Table Management Practices MGT 330: Management for Organizations Professor Edris Gehy Jason Campbell 6/22/2014 Round Table Management Practices Management practices play crucial and decisive roles in allowing employees to work together for the accomplishment of common goals and objectives. An emphasis needs to be placed more upon reaching the predetermined goals just as much as to receive far better growth and progression for the company. There stays a great necessity to perform the business practices in a reliable way and with the successful implementation of management practices, the employees can be brought to together and learn to make the best possible use of available resources. Management practices guide and direct any organization to move forward along a proper path to ensure success. The management practices of planning, leading, organizing, staffing and controlling are being implemented in nearly all workplaces, and are able to derive far better results than previously unorganized systems. These five management functions have been validated and proven to be worthwhile in setting goals and objectives, and I will show the difference between management at my place of employment, and effective management in this paper. The initial step in effective managing is planning. This involves forming the mission, vision and objectives of the company and laying out a detailed plan for the way through these goals are to be attained. In the...

Words: 2143 - Pages: 9


...University of Phoenix Material Website Review Find national, state, and local governmental health agency websites that address the issue you selected in your Week One assignment. Follow the example to document your findings in the table. Health issue: _Teen Pregnancy__________________________ |Website |Website Information Type |Type of Surveillance: |Data changes over time: |Identify two interventions | | | |survey, self report, |Has the incidence |that affect the issue. | | | |statistics, case report, |increased or decreased? | | | | |and so forth | | | |Example: |Table of contents, search, |Statistics and |Swine flu incidences have |Vaccine, hand washing, and | | |print, videos, surveillance |self-reporting |decreased. There are now |isolation masks...

Words: 295 - Pages: 2

Symbol Table

... A symbol table is a data structure used by a language translator such as a compiler or interpreter, where each identifier in a program's source code is associated with information relating to its declaration or appearance in the source, such as its type, scope level and sometimes its location. 1 Uses An object file will contain a symbol table of the identifiers it contains that are externally visible. During the linking of different object files, a linker will use these symbol tables to resolve any unresolved references. A symbol table may only exist during the translation process, or it may be embedded in the output of that process for later exploitation, for example, during an interactive debugging session, or as a resource for formatting a diagnostic report during or after execution of a program. 2 Implementation If a compiler is to handle a small amount of data, then the symbol table can be implemented as an unordered list, which is easy to code, but it is only suitable for small tables only. A symbol table can be implemented in one of the following ways: • Linear (sorted or unsorted) list • Binary Search Tree • Hash table 3 Operations A symbol table, either linear or hash, should provide the following operations. insert() This operation is more frequently used by analysis phase, i.e., the first half of the compiler where tokens are identified and names are stored in the table. This operation is used to add information in the symbol table about......

Words: 360 - Pages: 2

Force Table

... the component method, all vectors are regarded as beginning at the origin. The vectors are then resolved into x and y components. These components are then added algebraically, and the sum of the x and y components represent the components of the sum of the vectors. ANALYTICAL METHOD USING TRIGONOMETRIC IDENTITIES The law of cosines and the law of sines can be used to find the magnitude and direction of the resultant when two vectors are added together by the head to tail method. Consider a triangle whose sides a and b represent two vectors added together, and side c represents the resultant vector. Then let angle α be opposite side a, angle β opposite side b and angle γ opposite side c. The law of cosines is then c2 = a2 + b2 − 2ab cos γ, and the law of sines is sin α sin β sin γ = = . a b c These formulas can be proved from the basic trigonometric definitions. Note that in the special case of γ = 90◦ , the law of cosines becomes the Pythagorean theorem, and the law of sines follows from the definition of the sine function. 1 GENERAL PHYSICS I EQUIPMENT Force table, Four pulleys, Four plastic hangers (5 grams each), Weight set (weights of 5, 10, 20 ,50 and 100 grams), String, Bull’s eye level, Meter stick or other measuring device, Protractor. PROCEDURE EXPERIMENT NO. 5 0. When adding weight make sure you consider the weight of the hanger! Since the hanger weighs 5 grams, if you want 50 grams you need add 45 to the hanger, etc. 1. Check to see that your force table......

Words: 997 - Pages: 4

Decision Table

...Question: A company has various rules for how payments to suppliers are to be authorized. Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accounting clerk can immediately issue a check against that purchase order and sign the check. For approved purchase orders between $5,000 and $10,000, the accounting clerk can immediately issue a check but must additionally obtain a second signature. Payments for approved purchase orders over $10,000 always require the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments that are not covered by a purchase order that are under $5,000 must be approved by the accounting manager and a departmental manager that will absorb the cost of the payment into that department’s budget. Such checks can be signed by a single accounting clerk. Payments that are not covered by a purchase order that are between $5,000 and $10,000 must be approved by the accounting manager and a departmental manager, and the check must have two signatures. Finally, payments exceeding $10,000 that are not covered by a purchase order must be approved by a department manager, the accounting manager, and the chief financial officer. Such checks require two signatures. Use a decision table to represent the logic in this process. Write down any assumptions you have to make. SOLUTION Conditions/Courses of action | Rules | | 1 | 2 | 3 | 4 | 5 | 6 | Purchase...

Words: 329 - Pages: 2

2006 Table

...[Type text] Taper Protection Table 2006 Members Date of birth from 02.04.1962 02.05.1962 02.06.1962 02.07.1962 02.08.1962 02.09.1962 02.10.1962 02.11.1962 02.12.1962 02.01.1963 02.02.1963 Date of birth to 01.05.1962 01.06.1962 01.07.1962 01.08.1962 01.09.1962 01.10.1962 01.11.1962 01.12.1962 01.01.1963 01.02.1963 01.03.1963 Date of end of protection 31.03.2022 06.02.2022 14.12.2021 23.10.2021 29.08.2021 06.07.2021 15.05.2021 21.03.2021 28.01.2021 05.12.2020 11.10.2020 02.03.1963 02.04.1963 02.05.1963 02.06.1963 02.07.1963 02.08.1963 02.09.1963 02.10.1963 02.11.1963 02.12.1963 02.01.1964 02.02.1964 02.03.1964 02.04.1964 01.04.1963 01.05.1963 01.06.1963 01.07.1963 01.08.1963 01.09.1963 01.10.1963 01.11.1963 01.12.1963 01.01.1964 01.02.1964 01.03.1964 01.04.1964 01.05.1964 23.08.2020 30.06.2020 09.05.2020 15.03.2020 23.01.2020 30.11.2019 06.10.2019 15.08.2019 22.06.2019 30.04.2019 07.03.2019 12.01.2019 22.11.2018 29.09.2018 02.05.1964 02.06.1964 01.06.1964 01.07.1964 07.08.2018 14.06.2018 02.07.1964 02.08.1964 02.09.1964 02.10.1964 02.11.1964 02.12.1964 01.08.1964 01.09.1964 01.10.1964 01.11.1964 01.12.1964 01.01.1965 22.04.2018 27.02.2018 04.01.2018 12.11.2017 19.09.2017 29.07.2017 02.01.1965 02.02.1965 01.02.1965 01.03.1965 04.06.2017 11.04.2017 02.03.1965 02.04.1965 01.04.1965 01.05.1965 21.02.2017 29.12.2016 02.05.1965...

Words: 461 - Pages: 2

Sample of Pivot Table

... Micro Credit Scheme in 1994. Micro Credit Scheme provides for the poor for generation of employment and income on a sustainable basis particularly in urban and suburban areas. The bank also provides funds to investment and leasing companies. The Bank has recently created a venture capital fund for equity support to innovative but risky projects. BASIC Bank runs its communication process in various ways. Such are Internal Communication, External Communication, Grapevine, etc. By using these different forms of communication BASIC Bank communicates with its employees (upper, middle & lower), clients, regulatory authority, and suppliers. In this report we tried to present the basic communication that has been played by BASIC Bank. 18 Recommendation: 1. Being state hold organization it faces difficulty in administrative communication. 2. Customer focus should be emphasized. 3. Advanced training facilities for employees should be arranged. 4. General banking activities needs to be more developed to attract general people (ATM service increase, different savings scheme, easy information facilities, etc.). 5. More advertisement should be promoted to make the bank familier. 6. New technological improvisation should be installed with the existing 19 D.......

Words: 3420 - Pages: 14

Media Table

...Systems Media Table: Comparison Using this table, prepare and submit a 30 - 50 word response in each box that describes the purposes for each system, and gives examples and uses for each system. In addition, prepare and submit an APA-formatted reference page with at least five references. |System |Purposes |Examples |Uses | |Word processor |Word Processors are systems that are used |Some examples of the word processors |Word processors are used | | |to create documents. It is a software |available are Microsoft Word, |in the creation of | | |program capable of creating, storing, and |WordPerfect, Lotus Word-Pro, Open |documents such as | | |printing documents. These programs give the|Office Write, Ability Write, |letters, academic papers,| | |user the ability to format and edit the | |memos, or anything | | |document (Englebradt & Nelson, 2002). The | |written with text. There| | |use of creative fronts, colors and graphics| |are many templates that | | |also allows for creativity but “should not | |are...

Words: 2833 - Pages: 12