Excel Question - Pivot Tables Sorting

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?

Sorry, never mind, I figured it out.

COUNTIF function? Not in a pivot table, but it can give you a count of instances.