Compel Calculated Field with airSlate SignNow

Add custom logo, Add calculated fields and eSign

after you create a pivot table in Excel you can add custom formulas are there calculated fields or calculated items and in this video we'll see when to use either type of formula and what you can do with those formulas such as combining several items into one or adding something to the total with a special calculation this is Debra Dalgleish from context choose calm the two types of formulas in a pivot table are calculated field and calculated item to create either of those we would select a cell in the pivot table go up to the analyze tab click fields items and sets and then we have a choice calculated field or item the calculated field lets us work with any of the fields in the pivot table and the calculated items lets you work with any items in a specific field so we'll try a calculated item first and what we're going to do is work with this order status and instead of having cancelled plus three different types below it we're going to combine all of these three into something called sold here I'll click calculated item and the first thing we would do is give this a name and I'm going to call it sold and then we have to create our formula in it right now just shows equal zero and we can see all the fields in our pivot table here and because I have order status selected that's the one that it has highlighted in this list of fields and it's showing all the items but I could do something with any of the other fields if I prefer if I wanted to work with the regions I could click it and see its items but we'll go back to order status and what we want to do is get the total for back order plus pending plus shipped and to do that I'm going to double click on back order and that puts it up into the formula so I didn't have to delete what was there it just deleted that for me and put back order in then I'll do a plus and pending I'll double-click it plus shipped so we're going to get the total of those three and I'll click Add and ok now what's happened is it still has canceled our other three items and sold so we're getting double the amount for each of these items so the last step here would be to hide the three items that are being included in sold and now we just have canceled and sold so that's a very simple calculated item the other type of formula in a pivot table is a calculated field this is the same data i've now listed all the sales reps here how many total units they sold and the total amount of their sales we're going to give everyone a bonus and it's going to be based on what total they...