Hello,

When I create what I believe is a relatively simple pivot table, the data in the "body" of the pivot table is displayed as 01-01-1900 as shown in the image:
Pivot table issue 1.PNG

The data I am creating the pivot from is as follows:
Pivot table issue 2.PNG

I would like my pivot table to look like the screenshot below so I can easily total up the values to see the most regular failure:
Pivot table issue 3.PNG

I am new to pivot tables so maybe I have done something very obvious but any help is apprciated.

Thanks,
D