if you arent sure how to solve it, please let someone who does answer it . thank you .
M25 4 B D E F G H J K M 1 Your goal is to import three text files with sales data using Power Query and then make a PivotTable Report as seen to the right -> 2. You will need to download the attached zipped folder named "Testo3-TextFiles.zip" and then unzip it to get the three text files. 3. A picture of the three text files is seen here > 2018Sales.bit 2019Sales.it 5 2020Sales.but 6 7 When you load the appended tables for the years, 2018, 2019 and 2020, load the table as a new sheet and name the sheet smartly. 8. When you create the Pivot Table put it on the Worksheet that you loaded the data to. 9 10 11 12 13 Date Product StoreID Sale 14 12/22/2018 Phoenix Seattle 1171.99 15 B/26/2018 Aspen Oakland 87.72 16 5/22/2018 Bellen Portland 195.02 17 2/10/2018 Phoenix Oakland 648.47 18 9/10/2018 Alpine Seattle 28.29 19 9/24/2018 Quad Seattle 757.45 20 5/9/2018 Alpine Oakland 312.21 21 12/17/2018 Quad Seattle 820.9 22 6/26/2018 Alpine Oakland 1473.03 27/18/2018 Quad Oakland 547.59 24 4/15/2018 Carlota Oakland 728.83 25 2/18/2018 Sunset Tacoma 2089.38 26 10/18/2015 Quad Portland 111.9 27 7/29/2018 Bellen Seattle 2118.73 20 9/25/2018 Quad Oakland 733.67 29 10/15/2018 Sunset Portland 1859.17 30 9/16/2015 Quad Oakland 302.37 7/15/2018 Aspen Portland 1682.17 32 6/25/2018 Carlota Oakland 1389.01 3) 12/12/2013 Quad Oakland 55.65 6/5/2018 Quad Oakland 35 4/2/2013 Alpine Oakland Oakland 1812:54 11/6/2018 Quad Portland 36 /22/2018 Yanak Portland 65451 PU PB 20 Pivot Table Click in this area to work with the Pivot Table report DO M25 4 B D E F G H J K M 1 Your goal is to import three text files with sales data using Power Query and then make a PivotTable Report as seen to the right -> 2. You will need to download the attached zipped folder named "Testo3-TextFiles.zip" and then unzip it to get the three text files. 3. A picture of the three text files is seen here > 2018Sales.bit 2019Sales.it 5 2020Sales.but 6 7 When you load the appended tables for the years, 2018, 2019 and 2020, load the table as a new sheet and name the sheet smartly. 8. When you create the Pivot Table put it on the Worksheet that you loaded the data to. 9 10 11 12 13 Date Product StoreID Sale 14 12/22/2018 Phoenix Seattle 1171.99 15 B/26/2018 Aspen Oakland 87.72 16 5/22/2018 Bellen Portland 195.02 17 2/10/2018 Phoenix Oakland 648.47 18 9/10/2018 Alpine Seattle 28.29 19 9/24/2018 Quad Seattle 757.45 20 5/9/2018 Alpine Oakland 312.21 21 12/17/2018 Quad Seattle 820.9 22 6/26/2018 Alpine Oakland 1473.03 27/18/2018 Quad Oakland 547.59 24 4/15/2018 Carlota Oakland 728.83 25 2/18/2018 Sunset Tacoma 2089.38 26 10/18/2015 Quad Portland 111.9 27 7/29/2018 Bellen Seattle 2118.73 20 9/25/2018 Quad Oakland 733.67 29 10/15/2018 Sunset Portland 1859.17 30 9/16/2015 Quad Oakland 302.37 7/15/2018 Aspen Portland 1682.17 32 6/25/2018 Carlota Oakland 1389.01 3) 12/12/2013 Quad Oakland 55.65 6/5/2018 Quad Oakland 35 4/2/2013 Alpine Oakland Oakland 1812:54 11/6/2018 Quad Portland 36 /22/2018 Yanak Portland 65451 PU PB 20 Pivot Table Click in this area to work with the Pivot Table report DO
