I have (what I hope) is a simple excel question. FTR, I’ve never worked with PivotTables before today.
I have a spreadsheet with thousands of rows with two columns: “Majors” and “Job Titles.”
I’ve sorted them by major and then alphabetically by job title, and then I made a Pivottable with this information. (So far, so good.)
So in the pivotTable, when I click “Majors,” a column of all Job Titles is displayed alphabetically. It removed duplicates and blanks (good). But I would like it to sort by how often a title occurred in the column per major, not alphabetically. Is this possible?
Even better, additionally I would like to generate a report/table that says how many times each title appears in each major, and to disregard any job title that appears less than a certain number of times. But I have no idea on how to go about this, or what to search for in help. Any ideas?