Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am trying to find the logical questions from the pivot table I built and enlist the reason why this pivot can indicate those quetsions.

image text in transcribedI am trying to find the logical questions from the pivot table I built and enlist the reason why this pivot can indicate those quetsions.

fr G No P Region Year (All) Column Labels C Chicago C Total NE Boston Detroit Minneapolis St Louis NYC Philadelphia Wash. D Year 2015 2016 2017 2018 2019 2020 2016 2017 2018 2019 2015 2016 2017 F Profit 1926 6599 4156 -156 9132 9136 -1050 9298 1997 408 2241 1350 187 5251 4601 Pivot Table Fields Choose fields to add to report: City Region Product Year Sales Profit MORE TABLES... 493147 38532.11 349446 28184.11 3075814113851561559 31905.529 24175.197 122796.946 Product ABC DEF GHI JKL MNO PQR ABC DEF GHI JKL MNO PQR ABC DEF GHI 499484 394589 39564.56237244.172 452461 38227.762 18 w w 251812 23817.16 385321 43248.17 419518 27913.75 432178 45154.13 1488829 140133.21 362160 26324.75 554492 39507.62 410997 46054.81 192732 14656.009 443450 30480.771 197675 2 0342.4 1326672 103017.518 325207 25936.172 335597 26697.552 416473 26806.967 37538.338 N18 X City 2 Los Angeles 3 Los Angeles 4 Los Angeles 5 Los Angeles 6 Los Angeles 7 Los Angeles 8 Los Angeles 9 Los Angeles 10 Los Angeles 11 Los Angeles 12 Los Angeles 13 Los Angeles 14 Los Angeles 15 Los Angeles 16 Los Angeles 17 Los Angeles 18 Los Angeles 19 Los Angeles 20 Los Angeles 21 Los Angeles 22 Los Angeles Los Angeles 24 Los Angeles 25 Los Angeles 26 Los Angeles 27 Los Angeles 28 Los Angeles 29 Los Angeles Los Angeles 31 Los Angeles 32 Los Angeles 33 Los Angeles Data 200 2018 2019 2015 582733 E Sales 32098 65987 23091 7821 83017 45678 35009 58113 99867 4530 56023 6748 9821 58342 46009 32098 65987 23091 7821 83017 45678 35009 58113 99867 4530 56023 6748 9821 58342 46009 77864 6745 Row Labels ABC Sum of Sales Sum of Profit DEF Sum of Sales Sum of Profit GHI Sum of Sales Sum of Profit JKL Sum of Sales Sum of Profit MNO Sum of Sales Sum of Profit POR Sum of Sales Sum of Profit (blank) Sum of Sales Sum of Profit Total Sum of Sales Total Sum of Profit 586883 45784.25 233149 17885.87 467214 31320.05 1869979 146568.17 264605 26784.87 326694 23446.42 419328 31158.93 JKL 4173 MNO 2016 2017 Drag fields between areas below: 213782 21446.424 362439 34448.549 342079 33806.46 4 63830 19704.722 1382130 109406.155 478583 45922.118 428581 36193.542 447104 31364.973 18 Y FILTERS Year PQR ABC DEF GHI JKL MNO PQR II COLUMNS Region City 374212 20505.21 344951 25783.37 423066 27609.88 230083 26414.78 1372312 100313.24 430667 43308.21 404446 46392.78 346470 39980.7 10 7259 4849 1408 6641 3197 -2101 3487 9987 815 -1120 742 1964 -1750 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 ABC ROWS 2412651 187623.492 2217622 197898.208 2 168843 169602.26 2202365 167111.279 9001481 2360706 2444399 722235.239 207840.682 209482.086 2492833 13 213594.142 1127 Product Values VALUES Sum of Sal... Sum of Pr... DEF GHI JKL MNO PQR ABC DEF 7361 9344 607 w 2016 Text Response + Defer Layout Upda... UPDATE fr G No P Region Year (All) Column Labels C Chicago C Total NE Boston Detroit Minneapolis St Louis NYC Philadelphia Wash. D Year 2015 2016 2017 2018 2019 2020 2016 2017 2018 2019 2015 2016 2017 F Profit 1926 6599 4156 -156 9132 9136 -1050 9298 1997 408 2241 1350 187 5251 4601 Pivot Table Fields Choose fields to add to report: City Region Product Year Sales Profit MORE TABLES... 493147 38532.11 349446 28184.11 3075814113851561559 31905.529 24175.197 122796.946 Product ABC DEF GHI JKL MNO PQR ABC DEF GHI JKL MNO PQR ABC DEF GHI 499484 394589 39564.56237244.172 452461 38227.762 18 w w 251812 23817.16 385321 43248.17 419518 27913.75 432178 45154.13 1488829 140133.21 362160 26324.75 554492 39507.62 410997 46054.81 192732 14656.009 443450 30480.771 197675 2 0342.4 1326672 103017.518 325207 25936.172 335597 26697.552 416473 26806.967 37538.338 N18 X City 2 Los Angeles 3 Los Angeles 4 Los Angeles 5 Los Angeles 6 Los Angeles 7 Los Angeles 8 Los Angeles 9 Los Angeles 10 Los Angeles 11 Los Angeles 12 Los Angeles 13 Los Angeles 14 Los Angeles 15 Los Angeles 16 Los Angeles 17 Los Angeles 18 Los Angeles 19 Los Angeles 20 Los Angeles 21 Los Angeles 22 Los Angeles Los Angeles 24 Los Angeles 25 Los Angeles 26 Los Angeles 27 Los Angeles 28 Los Angeles 29 Los Angeles Los Angeles 31 Los Angeles 32 Los Angeles 33 Los Angeles Data 200 2018 2019 2015 582733 E Sales 32098 65987 23091 7821 83017 45678 35009 58113 99867 4530 56023 6748 9821 58342 46009 32098 65987 23091 7821 83017 45678 35009 58113 99867 4530 56023 6748 9821 58342 46009 77864 6745 Row Labels ABC Sum of Sales Sum of Profit DEF Sum of Sales Sum of Profit GHI Sum of Sales Sum of Profit JKL Sum of Sales Sum of Profit MNO Sum of Sales Sum of Profit POR Sum of Sales Sum of Profit (blank) Sum of Sales Sum of Profit Total Sum of Sales Total Sum of Profit 586883 45784.25 233149 17885.87 467214 31320.05 1869979 146568.17 264605 26784.87 326694 23446.42 419328 31158.93 JKL 4173 MNO 2016 2017 Drag fields between areas below: 213782 21446.424 362439 34448.549 342079 33806.46 4 63830 19704.722 1382130 109406.155 478583 45922.118 428581 36193.542 447104 31364.973 18 Y FILTERS Year PQR ABC DEF GHI JKL MNO PQR II COLUMNS Region City 374212 20505.21 344951 25783.37 423066 27609.88 230083 26414.78 1372312 100313.24 430667 43308.21 404446 46392.78 346470 39980.7 10 7259 4849 1408 6641 3197 -2101 3487 9987 815 -1120 742 1964 -1750 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 ABC ROWS 2412651 187623.492 2217622 197898.208 2 168843 169602.26 2202365 167111.279 9001481 2360706 2444399 722235.239 207840.682 209482.086 2492833 13 213594.142 1127 Product Values VALUES Sum of Sal... Sum of Pr... DEF GHI JKL MNO PQR ABC DEF 7361 9344 607 w 2016 Text Response + Defer Layout Upda... UPDATE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions