Excel Pivot Table Challenge - Is this possible

I have the following data (this is vastly oversimplified as I have many more columns and rows)

GrThan100 Athl? Mil? B2B?
Y Y Y Y
Y N N Y
Y N Y Y
Y N N Y
N N N N
N N Y N

What I want to create is a summary pivot table like (a count for each column by the values in the GrThan100):

Athl Mil B2B
GrThan100 Y N Y N Y N
Y 1 3 2 2 4 0
N 0 2 0 1 0 2

However, when I use the pivot table it complicates matters by also grouping each column value together (see below for just 2 counted variables)

Athl? Military? Data
N Y
N Y N
GrThan100 Quota? Count of Athl? Count of Military? Count of Athl? Count of Military? Count of Athl? Count of Military?
N 43 43 2 2 10 10
Y 53 53 2 2 12 12
Grand Total 96 96 4 4 22 22

I can work with this for 2 columns of counted data but it gets exponentially harder with each column I add in. Right now I am manually creating a single pivot for each column and then manually adding them up in a seperate spreadsheet...but with so many columns this takes too much time....see below for examples of each indiv. pivot. Any help would be great so I could do all of this in one step!!!


Count of Athl? Athl?
GrThan100 Quota? N Y (blank) Grand Total
N 45 10 55
Y 55 12 67
Grand Total 100 22 122



Count of Military? Military?
GrThan100 Quota? N Y (blank) Grand Total
N 53 2 55
Y 65 2 67
Grand Total 118 4 122