How to Change a Calculation in a Pivot Table in Microsoft Excel 2007

Description

Learn how to change calculations in a Pivot Table.

Transcript
Now, instead of calculated items or calculated fields, we can also just change the calculation that Excel is giving us in the pivot table. As an example, I am going to remove the region field and add the customer and product field. When customers are going down the side, I want products going across the top so I will drag those on the column labels. Now, you will notice that in cell A3, it says that we are looking at the sum of Revenue. Every pivot table that we have created so far in this lesson has been showing us the sum of revenue. It turns out that we have control over that calculation. You need to select one cell that contains Revenue and then choose the field settings button on the ribbon. You will notice that we have choices here that show a sum, account, an average, max, min, and product. There is also standard deviation and variance if you would scroll down. Another very interesting option is on the show values as tab. Right now, Excel is showing us the values as normal. There are several options in that dropdown including percentage of row, click okay. In this case, Excel will replace our revenue numbers with percentages that total across to a 100%. This allows you for any particular customer to see what percentage of product mix they buy. Other settings and field settings include percentage of column. In this case, for each product, for example B713 in column C, you can see which customers buy a certain percentage of that product. These calculations will total a 100% along the bottom. I am going to remove customer from the pivot table and put date along the left hand side, go back into field settings and change the running total in. I want to show a running total in the date field and now instead of percentages, I will see cumulative year to date figures.
Related Articles

How to Change a Calculation in a Pivot Table in Microsoft Excel 2007

Earn Forex Pivot Points Calculator - Pivot Points Calculation Rules

The presented article covers the topic of pivot points calculating. Different pivot points are the popular and simple tools of technical analysis in Forex market trading. In this article the rules for floor, Tom Demark\'s, Woodies and Camarilla pivots are described. The following article will be useful for all Forex traders who wish to be more acquainted with the generic technical analysis....

Training Center - Microsoft Excel 2007 Course

The Microsoft Windows operating system and the Microsoft Office suite of productivity software are considered as Microsoft Corporation\'s two most profitable products. As of the third quarter of the year 2009, Microsoft Corporation was ranked as the third largest company in the world, and one of the largest technological corporations in the world. So how about taking a Microsoft Excel 2007 course?...

Microsoft Access 2007 Training

Access 2007 was the most superior edition of the world\'s most accepted desktop database structure. It saw fundamental interface changes....

Microsoft Access 2007 Training

Access 2007 was the mainly complex version of the world\'s mainly trendy desktop database method. It saw fundamental border changes....

So Why Are There So Many Tables In Microsoft Project 2007?

Yes the tables in Microsoft Project can be very revealing, but because there are so many to choose from, you might just miss out on some essential data because you don\'t know its there. This article introduces you to four of the key tables and also looks at copying and editing a table to create you own tailored version....

Peewee Pivot 3. 0

Infants are of course curious. Usually when they will see a grownup, whether the idea be your parent or whatever, they generally wish to copy or maybe mimic what they notice. I can\'t explain how oftentimes I have got witnessed my own younger cousins pretending that will talk to the phone and also play using an ipod touch....

Sensitivity Analysis in Microsoft Excel

One of the finest features in Microsoft Excel is sensitivity analysis using either a table (Excel 2003) or 'What-if' in Excel 2007. Suppose you want to start a cybercafe or a restaurant in a new mall. You have done a study on the footfall and the kind of people who visit the mall....

Tidbits of Help - Excel 2007 - Formulas to Calculate Values

As I've mentioned before, Math and I (generally) aren't on speaking terms. Well, OK the higher end algebra type - yikes! So, anytime I can find a way for something else to do the math for me, I'll take it!...

Microsoft Office 2007 Professional

Home and Student 2007 includes OneNote, a digital notebook that helps you gather, organize, and search many types of information in one place...

Microsoft Office 2007 organizing information

Microsoft Office 2007 Home and Student Edition is the essential software suite for home computer users and includes 2007 versions of Excel, PowerPoint, Word and OneNote...