Pivot Tables<\/strong> are excellent tools in Excel that allow us to group the data based on different information.<\/p>\n\n\n\nIn the example below, we will show how can you manipulate columns of Pivot Tables<\/strong>, more precisely, how to divide one by another.<\/p>\n\n\n\nCreate a Pivot Table<\/h2>\n\n\n\n For our example, we will use the table with sales figures from various years presented in months, and buyers that company had to achieve those sales:<\/p>\n\n\n\n <\/figure>\n\n\n\nTo insert a Pivot Table<\/strong>, we will select our range, then go to Insert Tab >> Tables >> Pivot Table >> From Table\/Range<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOn the window that appears, we will simply click OK<\/strong>, and our Pivot Table<\/strong> will be created:<\/p>\n\n\n\n <\/figure>\n\n\n\nDivide one Column By Another in Pivot Table Calculated Field<\/h2>\n\n\n\n Now that we have the table created, we will add the Month field in Rows<\/strong>, and the Sum of Revenues<\/strong> and Sum of Buyers in Values fields<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOur Pivot Table<\/strong> looks like this:<\/p>\n\n\n\n <\/figure>\n\n\n\nNext, we want to see how much revenue the company generates per buyer. To add this field, we will click on our table, and then go to PivotTable Analyze >> Calculations >> Fields, Items, & Sets >> Calculated Field<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOn the pop-up window that appears, we will give the name to our field- \u201cRevenuePerBuyer\u201d<\/strong> and we will choose the revenues and buyers<\/strong> from our Pivot Table<\/strong>, and finally divide these fields:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will click OK<\/strong>, and will have the new field inserted:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will format<\/strong> these numbers as<\/strong> dollars<\/strong>. We can see that how the Calculated Field<\/strong> works is that the name of the new column always begins with \u201cSum of\u2026\u201d<\/strong> and then our name is added, as Sum is the custom option in the Values field<\/strong>. This is what our final table looks like:<\/p>\n\n\n\n <\/figure>\n","protected":false},"excerpt":{"rendered":"Excel is perhaps the best overall product for preparing and presenting our data. Pivot Tables are excellent tools in Excel that allow us…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Divide One Column by Another in Pivot Table Calculated Field<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n