In Excel, filters make it easy to exclude data from PivotTables. You can check off the desired categories, and watch the numbers change throughout: The fancy word for this property is filter context — the data that gets returned is everywhere dependent on the context of the filter. But what if you wanted to return … Continue reading How to use the ALL() function in Excel Power Pivot