Excel 2010 Pivot Tables: Add Calculated Columns, Measures


show more Adding calculated columns and measures provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Adding calculated columns and measures

After you import data into your Excel, you might find you want to summarize your data in a way that's not included in the original table. For example, your table might include a Price column and a Quantity column, but not a column that multiplies those values together to find the total for each row. If you do want to multiply those values together, you can create what's called a calculated column. You can also summarize your data using a measure, which you can use within a PivotTable. In this movie I'll show you how to create both calculated columns and measures.

To begin I'll jump into PowerPivot, so I'll click the PowerPivot tab on the Ribbon and then the PowerPivot Window button to display my data within PowerPivot and now to create a calculated column I click over in the Add Column column and then I can start typing my formula. In this case I'll type an equal sign and you can see the formula here on the Formula bar, and then I'll type the names of the fie...

Adding calculated columns and measures
Video duration: 4m 22s 3h 43m Intermediate

Viewers:

Adding calculated columns and measures provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...