I have a pivot table with 2 columns. Column A is "genre" and Column B is "count". All together there are 211 films counted across all 10 genres. 4 of the individual genres have a count of less than 10 as a result and I need to lump those results into a new genre called "other". The result would be the 6 genres that have a count of 10 or more + the new "other" category, which would sum the count of the genres that have less than 10, and the result would still total 211. Ideas?
Thanks in advance!
-Derek
Thanks in advance!
-Derek