B E G A C D F H PivotTable Fields X Date Customer ID Gender Pet type SKU purchased Amount 2 5/1/2017 750 Male Dog 40988 83.86 PivotTable3 Choose fields to add to report: 3 5/1/2017 636 Female Cat 22108 36.77 4 5/1/2017 839 Male Cat 33523 21.52 To build a report, choose Search 5 5/1/2017 816 Male Dog 56696 3.08 fields from the PivotTable 6 5/1/2017 867 Female Dog 94712 48.11 Field List Date 7 5/1/2017 499 Female Cat 33666 68.44 Customer ID Gender 8 5/2/2017 809 Female Cat 56001 3.53 9 5/2/2017 744 Male Cat 71808 11.14 Pet type SKU purchased 10 5/2/2017 661 Male Dog 29744 46.34 Amount 11 5/2/2017 625 Female Dog 53502 88.56 12 5/3/2017 903 Male Dog 53587 4.86 13 5/3/2017 271 Female Cat 52087 31.94 Drag fields between areas below. 14 5/3/2017 752 Female Dog 96829 72.00 7 Filters Columns 15 16 17 18 19 Rows E Values 20 21 22 Click here & if you can't see the image above. The spreadsheet above is used by a pet store. For each transaction, the following data are recorded: customer ID code, customer gender, pet type, SKU (item purchased), and cost of transaction.The store owner would like to create a contingency table displaying the count of customers by pet type and gender so that it looks like the following