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.

Видео Pivot Table: Calculated Fields vs Calculated Items канала Radu Popa