Hi HannahKirk,

I'm using Windows & was able to get that field to go into the other areas.

What I did was as per the below steps;

Copy the data & Paste Special into a new workbook & worksheet

Create the pivot from there.

I found your formatting & other settings were stopping me from getting it to work.

If there's a reason to have that formatting, try to add it after you've created the Pivot.

Hth