In total, how much revenue has been earned (total sales) in TX, using a pivot table on a seperate excel sheet?

Please explain how

E G H Dist 1 1 1 1 1 101 101 102 102 102 103 103 103 104 104 2 2 2 2 2 D F 1 Store City State Zipcode Phone# Region 2 101 Huntsville TX 33211864-555-1234 3 102 Conroe TX 33212 864-555-1235 4 103 New Orleans LA 33213 864-555-1236 5 104 Lake Charles LA 33214 864-555-1237 6 105 Spring TX 33215864-555-1238 7 106 Montgomery TX 33216864-555-1239 8 107 Navasota TX 33217864-555-1240 9 108 Moss Bluff LA 33218 864-555-1241 10 109 Jennings LA 33219 864-555-1242 11 110 Lafayette LA 33220864-555-1243 12 13 item Description Cost Price 14 12345 40 Watt Light Bulbs $1.60 $3.39 15 12346 60 Watt Light Bulb $3.20 $6.78 16 12342100 Watt Light Bull $6.40 $13.56 17 12348 200 Watt Light Bull $12.80 $27.12 18 12349 1000 Watt Light By $25.60 $54.24 19 20 S. In total, how much revenue has been earned (total sales) in TX? 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 item Store 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 101 102 103 104 105 106 107 108 109 110 101 102 103 104 105 106 107 108 109 110 101 102 103 104 105 101 102 103 104 105 106 107 108 109 110 101 102 103 104 105 106 102 Date 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/12/11 1/12/11 1/12/11 1/12/11 1/12/11 1/12/11 1/12/11 E G H Dist 1 1 1 1 1 101 101 102 102 102 103 103 103 104 104 2 2 2 2 2 D F 1 Store City State Zipcode Phone# Region 2 101 Huntsville TX 33211864-555-1234 3 102 Conroe TX 33212 864-555-1235 4 103 New Orleans LA 33213 864-555-1236 5 104 Lake Charles LA 33214 864-555-1237 6 105 Spring TX 33215864-555-1238 7 106 Montgomery TX 33216864-555-1239 8 107 Navasota TX 33217864-555-1240 9 108 Moss Bluff LA 33218 864-555-1241 10 109 Jennings LA 33219 864-555-1242 11 110 Lafayette LA 33220864-555-1243 12 13 item Description Cost Price 14 12345 40 Watt Light Bulbs $1.60 $3.39 15 12346 60 Watt Light Bulb $3.20 $6.78 16 12342100 Watt Light Bull $6.40 $13.56 17 12348 200 Watt Light Bull $12.80 $27.12 18 12349 1000 Watt Light By $25.60 $54.24 19 20 S. In total, how much revenue has been earned (total sales) in TX? 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 item Store 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 12347 12348 12349 12345 12346 101 102 103 104 105 106 107 108 109 110 101 102 103 104 105 106 107 108 109 110 101 102 103 104 105 101 102 103 104 105 106 107 108 109 110 101 102 103 104 105 106 102 Date 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/11/11 1/12/11 1/12/11 1/12/11 1/12/11 1/12/11 1/12/11 1/12/11