N18 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Los AngeEs Los AngeEs Los Angeles Los Angeles Los Ang&.s Los Los Angebs Los Los Angeles Los Ang&s Los Los Angebs Los Los Angeles Los Los Los Angebs Los Ang&s Los Angeles Los Angeles Los Los Angebs Los Los Angeles Los Angeles Los Los Angebs Los Ang&s Los Angeles Los Angeles Los Ang&s Los Data w w w w w w w w w w w w w Text Response c Product ABC DEF GHI JKL MNO ABC DEF GHI JKL MNO ABC DEF GHI JKL MNO ABC DEF GHI JKL MNO PQR ABC DEF GHI JKL MNO PQR ABC DEF D Year 2015 2016 2017 2018 2019 2020 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 65987 23091 7821 83017 45678 58113 99867 4530 56023 6748 9821 58342 65987 23091 7821 83017 45678 58113 99867 4530 6748 9821 58342 6745 1926 4156 -156 9132 9136 -1050 1997 2241 1350 187 5251 4601 4173 7259 4849 1408 6641 3197 -2101 3487 9987 815 -1120 742 1964 -1750 7361 607 Year Row Labels ABC Of Sales Sum Sum of profit DEF Sum of Sales Sum of Profit GHI Sum Sum JKL Sum of Sales of profit of Sales (All) Column Labels 493147 38532.11 251812 23817.16 492815 37538.338 586883 45784.25 213782 21446.424 374212 20505.21 2412651 187623.492 349446 28184.11 385321 43248.17 192732 14656.009 582733 51578 362439 34448.549 344951 25783.37 2217622 197898.208 Minneapolis 307581 31905.529 419518 27913.75 443450 30480.771 233149 17885.87 342079 33806.46 423066 27609.88 2168843 169602.26 St Louis 411385 24175.197 432178 45154.13 197675 20342.4 467214 31320.05 463830 19704.722 230083 26414.78 2202365 167111.279 C Total 1561559 122796.946 1488829 140133.21 1326672 103017.518 1869979 146568.17 1382130 109406.155 1372312 100313.24 9001481 722235.239 NE 499484 39564.562 362160 26324.75 325207 25936.172 264605 2678487 478583 45922.118 430667 43308.21 2360706 207840.682 o NYC 394589 37244.172 554492 39507.62 335597 26697.552 326694 2344642 428581 36193.542 404446 46392.78 2444399 209482.086 p Philadelphia 452461 38227.762 410997 46054.81 416473 26806.967 419328 31158.93 447104 31364.973 346470 39980.7 2492833 213594.142 w 2 2 11 PivotTable Fields x Choose fields to add to report: City Region Product Year Sales Profit MORE TABLES Drag fields between areas below: Sum of Profit MNO Sum of Sales Sum of Profit PQR Sum of Sales Sum Of profit (blank) Sum of Sales Sum of Profit Total Sum of Sales Total Sum Of profit Y FILTERS Year ROWS n COLUMNS City E VALUES Defer Layout IJpd