Pivot table not gathering all data
 

Is there a way for excel to gather data from multiple rows and columns for
one data label? I created a simple table that calculates the total number of
"X" under a particular data label but the table is only adding the first
column of data and does not continue on to the second, third, etc columns.