{"id":4951,"date":"2020-01-27T13:01:56","date_gmt":"2020-01-27T13:01:56","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=4951"},"modified":"2024-03-28T12:03:16","modified_gmt":"2024-03-28T12:03:16","slug":"pivot-table-add-a-calculated-field","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/pivot-table-add-a-calculated-field\/","title":{"rendered":"Pivot Table Add a Calculated Field"},"content":{"rendered":"\n
When you create a pivot table, you can see pivot fields from your original source. If you want, you can also create your own fields, called calculated fields.<\/p>\n\n\n\n
A calculated field is a field that uses data from the other pivot\ntable fields and makes calculations on them.<\/p>\n\n\n\n
Let’s create a very simple pivot table, using this very simple table. It has 10 names with the number of units sold and revenue made from the sales.<\/p>\n\n\n\n