I have a table with columns: First name, last name, course, grade, Max grade, min grade. There is a row for every course a person took. People occur more than once.

I want to create a pivot table with min-grade as the rows, Max grade as the columns, and distinct count as the values. Then group the min and max by 10s.

I can’t do a regular pivot and get distinct count and I can’t do a pivot with data model and get groupings of mid grade and max grade.

Is there a way to do this?