Lets say you have a table with race cars, color of car and finish times. I want to do a cross tab that groups by time let say for example 0-2mins, 2-4 mins, and 4+mins(group order). And also groups by car color. I want to exclude all blue cars (using select statement now). That part I have gotten to work. The problem is at the bottom I want to show percentages of the whole. So 0-2 mins 5 cars finished and there were 10 races(including the blue cars) I want 50%. Problem is I selected out the blue cars already. Anyone have any suggestions. (This is just an example will apply to work project)