How to Use Excel 2010 Filters with Aggregate Functions


show more Using filters in aggregate functions 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 ...

Using filters in aggregate functions

When you create a measure using an Aggregate function, PowerPivot calculates that measure's value for every row summarized in the PivotTable field. You can filter your PivotTable to limit your data but if you find yourself creating the same filter many times, you should consider creating a measure that incorporates that filter into its formula. In this movie, I'll show you how to do exactly that. So, we will jump into PowerPivot, clicking the PowerPivot tab on the Ribbon and the PowerPivot Window button, and we will create a measure that includes the filtered formula.

So to do that, we will click the PivotTable button to create a PivotTable andwe will put it on the new worksheet in Excel and click OK. Now remember that we need to use an Aggregate function such as SUMX for the filter to work. So, I'll create a new measure and I'll name it LargerOrders, and I will go down to Formula box. In an Aggregate function, you have the name of the function followed by the table and th...

Using filters in aggregate functions
Video duration: 5m 22s 3h 43m Intermediate

Viewers:

Using filters in aggregate functions 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 ...