Pivot Table: Calculated Fields vs Calculated Items

What is a calculated field in an Excel Pivot Table? What is a calculated item? What is the diference between them?
Let's find out in this video.
Pivot Tables not only summarize the data you already have, they can do much more. We can also have calculations, and this is where calculated fields and items come in handy:
Calculated fields are very useful when you want to create a new column in your Pivot without actually creating it in the source table.
Calculated items come in handy when you want to group certain categories inside your Pivot.

[@UniversalEngineer]

Great explanation. Thank you for the warnings and aspects to look out for. 👏

[@andreadickinson3076]

good job what I was looking for, ty

[@scooterza]

The reason that you calculated item is blanked out when you click IN the pivot table is that calculated items is a TEXT calculation. So it works with text fields. Since the middle of your pivot table is numeric, it won't work. As soon as you click on a text field, it starts to work.

[@andreausa123]

Thank you Sir !

[@naveenkumarc7081]

Gold 🔥

[@ahmed007Jaber]

hi
I have been using pivot tables for a bit and they are time saving at times.
I have a database of projects their budgets and costs. I know that I can create custom subtotals and custom calculated columns, but was wondering if i could add a line underneath a subtotal to do a calculation e.g. i have one budget for the whole project but several categories of expenses. So I need to show the breakdown of expenses and at the end sum of it and then a new line showing the value of surplus or deficit.
Another thing I just noticed, if I added it to a data model to create a measure and check the variance, I am not able to choose custom subtotals
I would prefer to do it without VBA, but if it is a must, why not

[@fardinkhan6027]

Well if I click on Calculated Items this appears to me "If one or more fields in the PivotTable have calculated items, no fields can be used in the data area two or more times, or in the data area and another area at the same time. If you are trying to add a field, remove the calculated items and add the field again. If you are trying to add a calculated item, change the PivotTable report so that no field is used more than once and then add the calculated item." Now please help me how can I use calculated item in excel.

[@simpalranjan5161]

Could you please let me know how we can add a calculated item in the power pivot table.

[@EyiBillion]

Brilliant!

[@FootballChad]

Thanks

[@FootballChad]

Can you help me how to calculate field in multiple combined date of pivot table

[@naveenkumarc7081]

Hi have you found this bro

[@sunil94256]

How to calculate difference between two calculated items?

[@naveenkumarc7081]

Hi have you found this please

[@pipo441]

Calculated fields is only possible when you use (drage) fields in the columns of your pivot table.

[@hazemali382]

great

[@SM-zp2qi]

Why create a video on a topic and say no idea?