CREATING CALCULATIONS IN A PIVOT TABLE in Font

Create PDF 417 in Font CREATING CALCULATIONS IN A PIVOT TABLE

CHAPTER 9 CREATING CALCULATIONS IN A PIVOT TABLE
PDF417 Maker In None
Using Barcode drawer for Font Control to generate, create PDF417 image in Font applications.
www.OnBarcode.com
Barcode Maker In None
Using Barcode maker for Font Control to generate, create Barcode image in Font applications.
www.OnBarcode.com
In the pivot table, Category is in the Row Labels area, Region is in the Column Labels area, and Sum of TotalPrice is in the Values area. 1. In the pivot table, right-click one of the value cells. For example, right-click cell B5, which is Bars for the East region. 2. In the context menu, click Summarize Data By, and then click More Options. 3. In the Value Field Settings dialog box, click the Show Values As tab. 4. From the drop-down list for Show Values As, select % Of. 5. You want to compare categories, so select Category as the Base field. 6. You ll compare the other categories to Bars, so select Bars as the base item. 7. It will be easier to compare the percentages with no decimal places, so click Number Format, and set Decimal places to zero, and then click OK to close the Format Cells dialog box. 8. Click OK to close the Value Field Settings dialog box. The values in the pivot table change to show each category s percentage of the Bars category sales. In Figure 9-6, the pivot table at the left shows the % Of custom calculations, and the original calculations (Normal) are in the pivot table at the right.
Generating Code 128 In None
Using Barcode generator for Font Control to generate, create Code 128A image in Font applications.
www.OnBarcode.com
Create DataMatrix In None
Using Barcode drawer for Font Control to generate, create DataMatrix image in Font applications.
www.OnBarcode.com
Figure 9-6. The pivot table at left shows the % Of custom calculation. The revised pivot table shows the percentage for each category compared to the Bars category. Instead of doing those calculations yourself, the pivot table did them for you, with a few clicks of the mouse. From the revised pivot table, the sales manager can quickly see how category sales differ. For example: Cracker sales in the North are 56 percent of bar sales in the North. Snack sales in the East are 19 percent of snack sales in the East. Total cookie sales are 136 percent of total bar sales.
PDF-417 2d Barcode Creator In None
Using Barcode maker for Font Control to generate, create PDF417 image in Font applications.
www.OnBarcode.com
Making Universal Product Code Version A In None
Using Barcode printer for Font Control to generate, create UPC-A Supplement 2 image in Font applications.
www.OnBarcode.com
Make a copy of the pivot table to display the normal values, and leave it on the worksheet, near the Tip
EAN128 Drawer In None
Using Barcode generator for Font Control to generate, create EAN / UCC - 14 image in Font applications.
www.OnBarcode.com
Planet Creation In None
Using Barcode creation for Font Control to generate, create Planet image in Font applications.
www.OnBarcode.com
pivot table with the custom calculations.
Create PDF417 In Java
Using Barcode encoder for Java Control to generate, create PDF-417 2d barcode image in Java applications.
www.OnBarcode.com
Drawing PDF-417 2d Barcode In .NET
Using Barcode encoder for VS .NET Control to generate, create PDF 417 image in .NET framework applications.
www.OnBarcode.com
CHAPTER 9 CREATING CALCULATIONS IN A PIVOT TABLE
EAN / UCC - 13 Creator In Java
Using Barcode maker for Android Control to generate, create European Article Number 13 image in Android applications.
www.OnBarcode.com
USS Code 39 Maker In Java
Using Barcode creator for BIRT Control to generate, create Code-39 image in BIRT reports applications.
www.OnBarcode.com
Using % Difference From
Encoding EAN13 In None
Using Barcode encoder for Online Control to generate, create EAN-13 image in Online applications.
www.OnBarcode.com
Draw GTIN - 12 In Visual Basic .NET
Using Barcode creation for Visual Studio .NET Control to generate, create GTIN - 12 image in Visual Studio .NET applications.
www.OnBarcode.com
Next, the sales manager wants to see whether sales in each region have changed from the beginning of 2007 to the end of 2007. Were there large fluctuations in the total sales per month, or were sales steady throughout the year in each region To create this report, you can use the % Difference From custom calculation. It s similar to the Difference From calculation that you used earlier, but it shows the difference as a percentage, instead of an amount. To analyze the data by month, you ll use the OrderDate, Region, and TotalPrice fields in the pivot table layout. First you ll change the TotalPrice field back to Normal calculation, so it will show the dollar amounts when you change the layout: 1. Right-click a value cell in the pivot table, choose Summarize Data By, and then click More Options. 2. In the Value Field Settings dialog box, click the Show Values As tab, and from the dropdown list for Show Values As, select Normal, and then click OK. 3. In the PivotTable Field List pane, remove Category from the Row Labels area. 4. Add OrderDate to the Row Labels area, leave Region in the Column Labels area, and leave TotalPrice in the Values area as Sum of TotalPrice. 5. Filter the OrderDate field so it shows dates in 2007 only. The pivot table now shows the order dates, with the total sales for each region (see Figure 9-7).
Data Matrix Reader In VB.NET
Using Barcode decoder for Visual Studio .NET Control to read, scan read, scan image in VS .NET applications.
www.OnBarcode.com
Drawing EAN13 In VS .NET
Using Barcode creation for .NET Control to generate, create UPC - 13 image in .NET framework applications.
www.OnBarcode.com
Figure 9-7. Total sales per date for each region You want to compare the totals to see how they change from one month to the next, so you ll use the % Difference From custom calculation to display the change.
Read USS Code 39 In Java
Using Barcode scanner for Java Control to read, scan read, scan image in Java applications.
www.OnBarcode.com
UPC - 13 Reader In VB.NET
Using Barcode scanner for Visual Studio .NET Control to read, scan read, scan image in .NET applications.
www.OnBarcode.com
Recognizing Code 128 Code Set C In None
Using Barcode reader for Software Control to read, scan read, scan image in Software applications.
www.OnBarcode.com
Generate Barcode In Java
Using Barcode generator for BIRT Control to generate, create Barcode image in Eclipse BIRT applications.
www.OnBarcode.com
Copyright © OnBarcode.com . All rights reserved.