please solve this question in xlsx file quickly >>>

1 calculate the followings by using Sumif or sumifs and pivot table 2 Total Sales Region Total Sales Northwest Southwest West SalesRep Total Sales June Chin Freddy 7 Date 10-20-19 10-21-19 10-22-19 10-23-19 10-24-19 10-25-19 10-26-19 Gigi 3 4 Date Region SalesRep Sales 5 10-20-19 West Gigi $620 6 10-20-19 Northwest Gigi $484 10-21-19 West Freddy $376 8 10-22-19 Northwest Freddy $1,141 9 10-23-19 Northwest Chin $725 10 10-24-19 West Chin $222 11 10-25-19 West June $1,038 12 10-21-19 Northwest Chin $154 13 10-22-19 Northwest Gigi $205 14 10-23-19 Southwest Gigi $895 15 10-24-19 West Chin $1,254 16 10-25-19 Northwest June $596 17 10-24-19 Southwest Gigi $799 18 10-24-19 Northwest Gigi $651 19 10-24-19 West June $1,235 20 10-24-19 Southwest Chin $684 21 10-25-19 Northwest June $127 22 10-26-19 West June $269 23 10-25-19 Southwest Chin $739 24 10-26-19 West Gigi $1,201 25 10-26-19 Northwest June $546 26 10-26-19 Northwest Chin $162 27 10-20-19 West Gigi $620 28 10-20-19 Northwest Gigi $484 29 10-20-19 West Freddy 30 10-20-19 Northwest Freddy 31 10-20-19 Northwest Chin 32 10-20-19 West Chin 33 10-20-19 West June 34 10-21-19 Northwest Chin 35 10-21-19 Northwest Gigi 36 10-21-19 Southwest Gigi 37 10-21-19 West Chin 38 10-22-19 Northwest June 39 10-24-19 Southwest Gigi 40 10-24-19 Northwest Gigi 41 10-24-19 West June 42 10-24-19 Southwest Chin 43 10-24-19 Northwest June 44 10-24-19 West June 45 10-25-19 Southwest Chin 46 10-25-19 West Gigi 47 10-25-19 Northwest June 48 10-25-19 Northwest Chin $376 $1,141 $725 $222 $1,038 $154 $205 $895 $1,254 $596 $799 $651 $1,235 $684 $127 $269 $739 $1,201 $546 $162