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
Bookmarks