I've got a big Excel file full of warranty data, and one of the columns is "Error Code". I want to see how many times each error code occurred, so I created a Pivot Table and added the "Error Code" to the my row labels, and it showed all the error code values in the spreadsheet, but I can't get it to show the number of times each code occurred in the column next to it. I've tried adding a calculated field and I've tried switching to "Count" in the field settings for the "Error Code" row label, but nothing happens. Any suggestions?
EDIT: I'm using Excel 2013
DOUBLE EDIT: I'm an idiot, I just had to drag the "Error Code" field to both the Row Label box and the Values box.
Bookmarks