Thanks for your help. It is along the right track, but is missing one piece which would make it a complete solution. I want all the "others" summed up in one lumpsum. Your workbook groups all the others into one (color) sector of the pie, however it does not add all the measures for this group. The "others" sector still has individual states listed along with their respective profit values - although all of these are now in the same color and hence not distinguishable.
I found this closely related solution by Jim Wahl, but it does not work for pie charts