{"id":23890,"date":"2021-12-15T06:16:59","date_gmt":"2021-12-15T05:16:59","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=23890"},"modified":"2024-02-06T15:50:03","modified_gmt":"2024-02-06T14:50:03","slug":"product-in-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/product-in-pivot-table\/","title":{"rendered":"Product in Excel Pivot Tables"},"content":{"rendered":"

\"Product<\/a><\/p>\n

With Pivot Tables<\/a> I will show you a cool trick on using what we call as flags<\/strong>. For example, we have a defect flag that marks if on that day we had a defect, then we can immediately summarize that data using Pivot Tables.<\/p>\n

Our main methodology will be using the Product in Pivot Table<\/a>. <\/strong>What this does is it will multiply all the values together.<\/p>\n

Exercise Workbook:<\/strong><\/em><\/p>\n

\n

Download excel workbook<\/i><\/span>Product.xlsx<\/span><\/a><\/p>\n

\n<\/div>\n

\n

Here is our data set. Notice that I have added a\u00a0Defects column. <\/strong>If there is a defect that day, we simply mark it as 1. This will be crucial once we use the\u00a0Product function<\/strong> later.<\/p>\n

\"Product<\/p>\n

STEP 1:<\/strong><\/span> This is our Pivot Table setup. Drag Defects<\/strong> to the\u00a0Values<\/strong> area:<\/p>\n

\"Product<\/p>\n

STEP 2:<\/strong><\/span> It will default as Sum of DEFECTS<\/strong>. Click on the arrow and select\u00a0Value Field Settings<\/strong><\/p>\n

\"Product<\/p>\n

Select\u00a0Product\u00a0<\/strong>and click\u00a0OK.<\/strong><\/p>\n

\"Product<\/p>\n

STEP 3:<\/strong><\/span> Now what Excel has done is for that specific duration, it has multiplied all the Defect values. So if any row for that specific duration has a 1, then the result in this Pivot Table is a 1 as well.<\/p>\n

We love the ones that show zero because that means there are no defects! For example, would be for Bottles\u00a0<\/strong>during the month of\u00a0September 2014.\u00a0<\/strong>Double click on it to see more details!<\/p>\n

\"Product<\/p>\n

You can see that in the data breakdown for September 2014<\/strong>, there are no defects! This is why the Product<\/strong> result is 0.<\/p>\n

\"Product<\/p>\n

Now try double-clicking on Ice Cubes <\/strong>during the month of\u00a0March 2013:<\/strong><\/p>\n

\"Product<\/p>\n

You can see it has defects, so which is why the Product result<\/strong> when you multiply them together is 1.<\/p>\n

\"Product<\/p>\n

Make sure to download our FREE PDF on the\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

With Pivot Tables I will show you a cool trick on using what we call as flags. For example, we have a defect flag that marks if on that day we had a defect, then we can immediately summarize that data using Pivot Tables. Our main methodology will be using the Product in Pivot Table. […]<\/p>\n","protected":false},"author":2,"featured_media":25361,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4],"tags":[850,849],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23890"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=23890"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23890\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/25361"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=23890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=23890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=23890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}