Hi Thomas,

These tutorials should help you identify the different uses for calculated fields vs calculated items:

https://www.myonlinetraininghub.com/excel-pivottable-calculated-fields

https://www.myonlinetraininghub.com/excel-pivottable-calculated-items

Please let us know if you have further questions.

Kind regards,

Mynda

Hey Thomas,

A Calculated Field is a calculation based on your Fields or Column Headers.

A Calculated Item is a calculation based on your Field's Items, so the unique items that are under each Column Header.

I hope this helps.

Cheers,

John

Calculated Fields are recommended to be preceded by a "*".  Is there any benefit in preceding Calculated Items with say a "#"?

Yes you can use a # to precede a Calculated Item, that way you can distinguish the calculation as being a Calculated Item.

Thanks,

John