Pivot Table: Calculated Fields vs Calculated Items

[@UniversalEngineer]

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

[@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.

[@andreadickinson3076]

good job what I was looking for, ty

[@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.

[@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

[@simpalranjan5161]

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

[@andreausa123]

Thank you Sir !

[@naveenkumarc7081]

Gold 🔥

[@FootballChad]

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

[@naveenkumarc7081]

Hi have you found this bro

[@EyiBillion]

Brilliant!

[@sunil94256]

How to calculate difference between two calculated items?

[@naveenkumarc7081]

Hi have you found this please

[@FootballChad]

Thanks

[@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?