Sort the list first by genre, then by title, and then by the season number Use the default sort values and sort order for each level. Using the subtotal button in the outline group on the data tab, add subtotals to the Sale Price column to calculate the average sale price and to count the number of TV shows by genre.
Solved by F. A. in 28 mins