You can see it has defects, so which is why the Product result when you multiply them together is 1. Now try double-clicking on Ice Cubes during the month of March 2013: You can see that in the data breakdown for September 2014, there are no defects! This is why the Product result is 0.

We love the ones that show zero because that means there are no defects! For example, would be for Bottles during the month of September 2014. Double click on it to see more details! Power Pivot is an Excel add-in you can use to perform. With Power Pivot you can mash up large volumes of data from various sources perform information analysis rapidly and share insights easily. Excel Pivot Tables Tutorial This tutorial shows how to add slicer to tables, pivot tables and pivot charts in Excel 2010, 2013, 20. So if any row for that specific duration has a 1, then the result in this Pivot Table is a 1 as well. On the Insert tab at the left theres a Tables group and heres the new tool which is Recommended Pivot Tables.

STEP 3: Now what Excel has done is for that specific duration, it has multiplied all the Defect values. Click on the arrow and select Value Field Settings STEP 2: It will default as Sum of DEFECTS. Manage subtotals within your Excel pivot tables. Understand the hierarchy Excel users when adding fields to a pivot table. Identify the best approach for formatting numbers with pivot tables. Identify how to expand and collapse groups of data within a pivot table. This will be crucial once we use the Product function later. Learn how to use the Recommended PivotTables feature in Excel 2013 and later. If there is a defect that day, we simply mark it as 1. Notice that I have added a Defects column.

Tutorial on pivot tables in excel 2013