Inserting Fields to Calculate Percentage in Excel with Pivot Tables

Posted by accountingweb on Feb 6 2004 620 printer friendly

With a PivotTable, you can insert additional data fields that you have already used and change the calculation function by which you create new calculated columns.
Insert an additional data field, Quantity field as an example.

Stage 1 – Add field to Data area.

Select any cell in Pivot Table area.
Right-click, and from the shortcut menu, select Wizard, Layout (in Excel 97, there is no need to select Layout).
Drag the Quantity field to the data area.
Click OK and Finish (in Excel 97, click only Finish).

Stage 2 - Changing the calculation function and formatting the field.

Select a cell in the data area of the new field you inserted (Sum of Quantity).
From the PivotTable toolbar, select Field Settings (in Excel 97, select PivotTable Field).
In the Name box, type % Quantity.
From Show Data as choose % Of Total.
Click OK.

Provided by ExcelTip.com

Voice of the Editor

What would you do if one of your clients won the lottery? We asked several accountants to weigh in with their advice for the lucky Powerball winner, and the tips we received are useful for anyone who receives a windfall, whether it's a lottery win, an inheritance, a big bonus on the job, or a killing in the stock market.

This Week on AccountingWEB

CPAs Mira Finé, Scott Hitchcock, Rob Keasal, Kathy Scorcio, and Ken Travis offer ten pieces of financial advice for the newest Powerball winner.

Hang Bower of BDO USA and Dan Black of Ernst & Young share their perspectives on why their firms made the Best Places to Work for Recent Grads 2013 list.

Herbein + Company, Inc. firm members talked with AccountingWEB about their year-round employee wellness program.

Bill Walter of Gross, Mendelsohn & Associates and Harold Gaar of TravisWolff LLP weigh in on mobile technology use while employees are at work.