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 …
Continue Reading about How to use the ALL()
function in Excel Power Pivot →