Create a PivotTable and save it in a new worksheet. The goal of this PivotTable is to summarise data and calculate total sales by transaction date and customer type (student, non-student). Use Transaction Date as a column label and Student? as a row label.

Package_Price 4 5 TRAN_ID TRAN_DATE CUST_ID PACK_CODE REP_ID PAYMENT_TYPE Student? 6 894026 3/4/2017 200939 5570 1132 credit card YES 7 936765 2/13/2019 205299 5487 1377 bank transfer YES 8 902950 11/21/2017 176434 5244 1126 online payment YES 9 988698 12/2/2016 213289 5635 1450 cash YES 10 884579 11/22/2016 205862 5030 1120 credit card YES 11 871486 3/12/2019 216377 5434 1157 bank transfer NO 12 911934 10/11/2018 215191 5405 1371 online payment NO 13 941051 7/19/2017 163408 5488 1155 cash YES 14 881082 3/6/2017 213288 5522 1064 credit card NO 15 853503 5/27/2018 158927 5319 1409 bank transfer NO 16 952222 9/19/2017 157993 5589 1015 online payment YES 17 930384 6/6/2016 204104 5218 1482 cash YES 18 942441 10/13/2016 169454 5527 1256 credit card YES 19 889981 6/9/2018 181555 5693 1379 credit card NO 20 979345 6/17/2017 179132 5103 1291 credit card YES 21 931094 1/4/2018 214145 5019 1292 credit card NO 22 860078 12/23/2016 214839 5332 1129 credit card NO 23 819685 4/7/2017 156836 5409 1165 credit card YES 24 921963 12/18/2017 175048 5271 1178 credit card YES 25 838343 1/6/2019 200758 5126 1355 credit card YES 26 860630 7/1/2016 164689 5634 1393 credit card NO 27 951051 5/15/2017 197348 5317 1426 credit card YES 28 892804 6/26/2018 183541 5410 1062 credit card NO 29 907527 8/3/2016 213824 5101 1443 credit card YES 30 838474 11/12/2018 159404 5679 1453 credit card NO 31 941562 8/23/2017 189118 5423 1034 credit card NO 32 944417 9/5/2018 172539 5236 1246 credit card NO Discount_Rate Total_Price $90.00 0.15 $76.50 $150.00 0.15 $127.50 $180.00 0.15 $153.00 $165.00 0.15 $140.25 $2,900.00 0.15 $2,465.00 $2,100.00 0.05 $1,995.00 $4,250.00 0.05 $4,037.50 $3,890.00 0.15 $3,306.50 $1,550.00 0.05 $1,472.50 $210.00 0.05 $199.50 $180.00 0.15 $153.00 $185.00 0.15 $157.25 $385.00 0.15 $327.25 $1,480.00 0.05 $1,406.00 $1,180.00 0.15 $1,003.00 $1,350.00 0.05 $1,282.50 $1,200.00 0.05 $1,140.00 $450.00 0.15 $382.50 $1,850.00 0.15 $1,572.50 $2,100.00 0.15 $1,785.00 $880.00 0.05 $836.00 $235.00 0.15 $199.75 $180.00 0.05 $171.00 $210.00 0.15 $178.50 $90.00 0.05 $85.50 $180.00 0.05 $171.00 $200.00 0.05 $190.00 Package_Price 4 5 TRAN_ID TRAN_DATE CUST_ID PACK_CODE REP_ID PAYMENT_TYPE Student? 6 894026 3/4/2017 200939 5570 1132 credit card YES 7 936765 2/13/2019 205299 5487 1377 bank transfer YES 8 902950 11/21/2017 176434 5244 1126 online payment YES 9 988698 12/2/2016 213289 5635 1450 cash YES 10 884579 11/22/2016 205862 5030 1120 credit card YES 11 871486 3/12/2019 216377 5434 1157 bank transfer NO 12 911934 10/11/2018 215191 5405 1371 online payment NO 13 941051 7/19/2017 163408 5488 1155 cash YES 14 881082 3/6/2017 213288 5522 1064 credit card NO 15 853503 5/27/2018 158927 5319 1409 bank transfer NO 16 952222 9/19/2017 157993 5589 1015 online payment YES 17 930384 6/6/2016 204104 5218 1482 cash YES 18 942441 10/13/2016 169454 5527 1256 credit card YES 19 889981 6/9/2018 181555 5693 1379 credit card NO 20 979345 6/17/2017 179132 5103 1291 credit card YES 21 931094 1/4/2018 214145 5019 1292 credit card NO 22 860078 12/23/2016 214839 5332 1129 credit card NO 23 819685 4/7/2017 156836 5409 1165 credit card YES 24 921963 12/18/2017 175048 5271 1178 credit card YES 25 838343 1/6/2019 200758 5126 1355 credit card YES 26 860630 7/1/2016 164689 5634 1393 credit card NO 27 951051 5/15/2017 197348 5317 1426 credit card YES 28 892804 6/26/2018 183541 5410 1062 credit card NO 29 907527 8/3/2016 213824 5101 1443 credit card YES 30 838474 11/12/2018 159404 5679 1453 credit card NO 31 941562 8/23/2017 189118 5423 1034 credit card NO 32 944417 9/5/2018 172539 5236 1246 credit card NO Discount_Rate Total_Price $90.00 0.15 $76.50 $150.00 0.15 $127.50 $180.00 0.15 $153.00 $165.00 0.15 $140.25 $2,900.00 0.15 $2,465.00 $2,100.00 0.05 $1,995.00 $4,250.00 0.05 $4,037.50 $3,890.00 0.15 $3,306.50 $1,550.00 0.05 $1,472.50 $210.00 0.05 $199.50 $180.00 0.15 $153.00 $185.00 0.15 $157.25 $385.00 0.15 $327.25 $1,480.00 0.05 $1,406.00 $1,180.00 0.15 $1,003.00 $1,350.00 0.05 $1,282.50 $1,200.00 0.05 $1,140.00 $450.00 0.15 $382.50 $1,850.00 0.15 $1,572.50 $2,100.00 0.15 $1,785.00 $880.00 0.05 $836.00 $235.00 0.15 $199.75 $180.00 0.05 $171.00 $210.00 0.15 $178.50 $90.00 0.05 $85.50 $180.00 0.05 $171.00 $200.00 0.05 $190.00