test
Ahmed20
excel_pivot_test.xlsxEx1
| Group Name |
| Buttersworth Co |
| Marleyville Tea |
| Marleyville Tea |
| Marleyville Tea |
| Postcards Store |
| Buttersworth Co |
| Postcards Store |
| Buttersworth Co |
| Buttersworth Co |
| Examineers Inc |
| Postcards Store |
| Buttersworth Co |
| FASST Trax |
| Hehehe |
| Randles Roadshack |
| Hehehe |
| Marleyville Tea |
| FASST Trax |
| Randles Roadshack |
| Examineers Inc |
| Randles Roadshack |
| Creepy Lada |
| Marleyville Tea |
| Buttersworth Co |
| Hehehe |
| FASST Trax |
| Hula Hoopers |
| Buttersworth Co |
| Randles Roadshack |
| Hehehe |
| Hehehe |
| Postcards Store |
| Randles Roadshack |
| Hula Hoopers |
| Buttersworth Co |
| FASST Trax |
| FASST Trax |
| Creepy Lada |
| Hehehe |
| Creepy Lada |
| Petie's Palace |
| Postcards Store |
| Examineers Inc |
| FASST Trax |
| Hehehe |
| Randles Roadshack |
| Hula Hoopers |
| Examineers Inc |
| Buttersworth Co |
| Postcards Store |
| Marleyville Tea |
| Creepy Lada |
| Buttersworth Co |
| Buttersworth Co |
| Examineers Inc |
| Examineers Inc |
| FASST Trax |
| Marleyville Tea |
| Creepy Lada |
| Hehehe |
| Jokes R Us |
| Marleyville Tea |
| Hehehe |
| Buttersworth Co |
| Randles Roadshack |
| Postcards Store |
| Examineers Inc |
| Marleyville Tea |
| Postcards Store |
| Postcards Store |
| Postcards Store |
| Buttersworth Co |
| Randles Roadshack |
| FASST Trax |
| Postcards Store |
| Marleyville Tea |
| Hula Hoopers |
| Buttersworth Co |
| Postcards Store |
| Hula Hoopers |
| Hehehe |
| Hehehe |
| Randles Roadshack |
| Hula Hoopers |
| FASST Trax |
| Postcards Store |
| FASST Trax |
| Buttersworth Co |
| Examineers Inc |
| Marleyville Tea |
| Hula Hoopers |
| Postcards Store |
| FASST Trax |
| Creepy Lada |
| Postcards Store |
| Hula Hoopers |
| FASST Trax |
| Petie's Palace |
| Randles Roadshack |
| Postcards Store |
| Examineers Inc |
| Buttersworth Co |
| Jokes R Us |
| Randles Roadshack |
| Buttersworth Co |
| Creepy Lada |
| Examineers Inc |
| Randles Roadshack |
| Examineers Inc |
| Examineers Inc |
| Hehehe |
| Buttersworth Co |
| Randles Roadshack |
| Postcards Store |
| Randles Roadshack |
| Postcards Store |
| Randles Roadshack |
| Marleyville Tea |
| Randles Roadshack |
| Hula Hoopers |
| Hehehe |
| FASST Trax |
| FASST Trax |
| Hehehe |
| Marleyville Tea |
| Postcards Store |
| Jokes R Us |
| Examineers Inc |
| Postcards Store |
| Marleyville Tea |
| Hula Hoopers |
| Postcards Store |
| Petie's Palace |
| Examineers Inc |
| Postcards Store |
| Examineers Inc |
| Creepy Lada |
| Randles Roadshack |
| Buttersworth Co |
| Jokes R Us |
| Examineers Inc |
| Hula Hoopers |
| Hehehe |
| Randles Roadshack |
| Petie's Palace |
| Creepy Lada |
| Jokes R Us |
| Petie's Palace |
| Hehehe |
| Buttersworth Co |
| Randles Roadshack |
| Hula Hoopers |
| Examineers Inc |
| Hula Hoopers |
| Examineers Inc |
| Creepy Lada |
| Creepy Lada |
| FASST Trax |
| Postcards Store |
| FASST Trax |
| Hula Hoopers |
| Buttersworth Co |
| Postcards Store |
| Jokes R Us |
| Randles Roadshack |
| Postcards Store |
| Randles Roadshack |
| Jokes R Us |
| Postcards Store |
| Buttersworth Co |
| Postcards Store |
| FASST Trax |
| FASST Trax |
| Marleyville Tea |
| Buttersworth Co |
| Hula Hoopers |
| Hula Hoopers |
| Petie's Palace |
| Hehehe |
| Randles Roadshack |
| Examineers Inc |
| Examineers Inc |
| Examineers Inc |
| Randles Roadshack |
| Marleyville Tea |
| Jokes R Us |
| Hula Hoopers |
| Postcards Store |
| Buttersworth Co |
| Hula Hoopers |
| Examineers Inc |
| Postcards Store |
| Examineers Inc |
| Hula Hoopers |
| Postcards Store |
| Postcards Store |
| Hehehe |
| Hehehe |
| Buttersworth Co |
| Hehehe |
| Jokes R Us |
| Petie's Palace |
| Marleyville Tea |
| FASST Trax |
| Creepy Lada |
| Petie's Palace |
| Examineers Inc |
| Examineers Inc |
| Hehehe |
| Marleyville Tea |
| Hula Hoopers |
| Buttersworth Co |
| Marleyville Tea |
| Examineers Inc |
| FASST Trax |
| Randles Roadshack |
| Hehehe |
| Postcards Store |
| Randles Roadshack |
| Postcards Store |
| Randles Roadshack |
| Examineers Inc |
| Randles Roadshack |
| Hehehe |
| Examineers Inc |
| Hula Hoopers |
| Hehehe |
| Jokes R Us |
| Hula Hoopers |
| Petie's Palace |
| Hula Hoopers |
| Examineers Inc |
| Randles Roadshack |
| Hula Hoopers |
| Marleyville Tea |
| FASST Trax |
| Postcards Store |
| Creepy Lada |
| Hehehe |
| Buttersworth Co |
| Hula Hoopers |
| Postcards Store |
| Hehehe |
| Hula Hoopers |
| Creepy Lada |
| Hula Hoopers |
| Randles Roadshack |
| Postcards Store |
| Jokes R Us |
| Postcards Store |
| Examineers Inc |
| Buttersworth Co |
| Hula Hoopers |
| Hehehe |
| Petie's Palace |
| Marleyville Tea |
| FASST Trax |
| Examineers Inc |
| Hula Hoopers |
| FASST Trax |
| FASST Trax |
| Examineers Inc |
| FASST Trax |
| FASST Trax |
| Jokes R Us |
| Randles Roadshack |
| Postcards Store |
| Randles Roadshack |
| Jokes R Us |
| Examineers Inc |
| Examineers Inc |
| Randles Roadshack |
| FASST Trax |
| Buttersworth Co |
| Petie's Palace |
| Hula Hoopers |
| Jokes R Us |
| Postcards Store |
| Hehehe |
| Buttersworth Co |
| Postcards Store |
| Marleyville Tea |
| Randles Roadshack |
| Jokes R Us |
| Randles Roadshack |
| Randles Roadshack |
| Creepy Lada |
| Buttersworth Co |
| Marleyville Tea |
| Marleyville Tea |
| Hehehe |
| FASST Trax |
| Hehehe |
| Creepy Lada |
| Postcards Store |
| Creepy Lada |
| Randles Roadshack |
| Creepy Lada |
| Marleyville Tea |
| Randles Roadshack |
| Hula Hoopers |
| Jokes R Us |
| FASST Trax |
| FASST Trax |
| Hula Hoopers |
| Creepy Lada |
| FASST Trax |
| Buttersworth Co |
| Creepy Lada |
| Postcards Store |
| FASST Trax |
Exercise 1: *You have a list of repeating group names. *Using a pivot table, count how many times each group name appears in the list. *Keep pivot table in this tab. Notice that this pivot table is a list comprised of each group name only occurring once. Then, within the pivot table, put the list in decreasing order based on the number of times the name appears in the list.
Ex2
| Group Segment | Revenue | Expenses |
| Medium | 8249.3276698127 | 594.878242008 |
| Medium | 6557.8729832219 | 83.3393859721 |
| Small | 6180.0357471981 | 551.2667803915 |
| Medium | 9915.4543112251 | 336.8576784372 |
| Small | 4047.6691780881 | 481.0083008923 |
| Small | 4797.0875045761 | 962.3550943443 |
| Small | 6537.8001010167 | 931.9697247837 |
| Medium | 3151.4227753704 | 848.2135170178 |
| Big | 9504.7818270498 | 827.5632244434 |
| Medium | 9378.1404699585 | 566.7976536033 |
| Big | 6772.1330424373 | 436.8799836118 |
| Small | 1854.6321581898 | 930.5482506081 |
| Big | 8303.942664325 | 680.7503719864 |
| Small | 6741.4600639306 | 418.0317384718 |
| Small | 4151.4397576795 | 336.4056384211 |
| Small | 7972.3018907032 | 917.1406009069 |
| Big | 10331.5784748428 | 440.4744097264 |
| Small | 3695.1930207613 | 217.656286454 |
| Small | 7904.2936251937 | 764.5839324212 |
| Medium | 849.2599248439 | 94.5170366431 |
| Big | 7157.6275489008 | 915.9245386615 |
| Medium | 3712.5650123251 | 432.5485875 |
| Small | 7596.4395031012 | 134.8225879903 |
| Small | 2198.6577925002 | 1037.2944248302 |
| Big | 4723.9958751125 | 463.2899115583 |
| Medium | 1331.2645180153 | 959.230732332 |
| Medium | 2743.8026187562 | 222.9192618727 |
| Big | 5038.3068133744 | 306.9576869105 |
| Small | 10458.2660169081 | 692.7631083142 |
| Small | 7567.0351493276 | 720.319063955 |
| Big | 7688.4341585784 | 851.8513374504 |
| Small | 4023.2273803651 | 166.4942195963 |
| Medium | 4551.6036698894 | 701.0456588856 |
| Medium | 2665.1140925001 | 654.9796658203 |
| Small | 6589.1246624486 | 278.188383772 |
| Medium | 5220.4269398047 | 589.1737959411 |
| Medium | 7282.1887565894 | 387.5496207223 |
| Small | 6444.5836306461 | 258.5026825916 |
| Small | 10299.0292603392 | 287.8049257787 |
| Small | 9841.2295754339 | 824.4756791813 |
| Small | 8237.8478361811 | 48.295935834 |
| Medium | 6221.2486222635 | 414.8820747116 |
| Medium | 5401.2418187665 | 877.9679090344 |
| Small | 10013.8111744499 | 807.8507674011 |
| Big | 8466.6998122226 | 450.5696925698 |
| Small | 8382.2143021092 | 958.2511684014 |
| Small | 8105.417292176 | 647.6468244176 |
| Small | 10051.2553898009 | 1003.7298818404 |
| Small | 3667.2011903398 | 680.7146779199 |
| Small | 7822.0618391282 | 924.356296138 |
| Small | 4575.5271715324 | 657.6493200788 |
| Small | 3178.1969187318 | 756.2079622278 |
| Small | 1734.4124287934 | 864.1463818564 |
| Medium | 8601.0660961888 | 666.9245543096 |
| Medium | 8328.4456772697 | 898.709187836 |
| Medium | 9715.2700007066 | 536.2618534938 |
| Medium | 4722.7733516562 | 837.7133331881 |
| Medium | 3434.6941177052 | 574.1248994173 |
| Small | 8696.7559833849 | 581.4444768178 |
| Medium | 9195.0795951441 | 1000.6729727959 |
| Big | 4168.8717148103 | 650.9037445718 |
| Big | 885.2432428382 | 323.976885302 |
| Medium | 3222.2105426214 | 760.2840912571 |
| Small | 3185.1817433305 | 455.4647279589 |
| Small | 5050.9759276909 | 618.3260163369 |
| Small | 306.0780834123 | 275.3065373107 |
| Small | 9598.9767485102 | 613.291159948 |
| Small | 10338.8006490912 | 979.8520025153 |
| Medium | 7350.6122898348 | 271.9879435914 |
| Small | 7506.4726445372 | 408.0083325832 |
| Small | 1939.7810982667 | 413.9417923424 |
| Big | 7692.2168494089 | 1015.8743011635 |
| Big | 1060.4865464279 | 607.3436711671 |
| Medium | 738.5081579279 | 431.474943255 |
| Small | 8174.8391784214 | 206.6453096591 |
| Small | 4368.8062371314 | 203.3753446594 |
| Small | 1292.5195029237 | 123.1056275262 |
| Big | 2210.7487570109 | 465.5261878633 |
| Big | 4240.7446320371 | 737.0688535015 |
| Small | 5927.0420304617 | 501.2388428822 |
| Small | 2597.3536595969 | 489.9869776835 |
| Small | 9549.4868167864 | 835.0236504696 |
| Small | 3931.3343697968 | 191.4213294839 |
| Small | 8578.8035799992 | 670.2412285641 |
| Big | 1946.1366556306 | 273.5117357051 |
| Medium | 9021.0164310181 | 402.0587254044 |
| Medium | 5575.6717397643 | 148.3339740683 |
| Big | 1193.0661622927 | 148.1347430675 |
| Small | 10340.5333462744 | 250.0846509055 |
| Small | 5512.7676568329 | 542.6187225193 |
| Medium | 2555.9990671807 | 824.1294903511 |
| Small | 10157.8136696377 | 508.1698277468 |
| Medium | 8921.5218567564 | 259.3318537021 |
| Big | 10494.443301691 | 565.4318597359 |
| Medium | 7007.7682447152 | 765.6916987833 |
| Medium | 4811.0377530315 | 193.174936848 |
| Small | 8657.8271850026 | 171.6024125265 |
| Medium | 8204.3205994819 | 278.7477843631 |
| Small | 4246.8831914754 | 644.5164909708 |
Exercise 2 There are preset 3 segments that all groups are put into: Big Medium Tiny Using a pivot table, create a table displaying Revenue for each segment. Keep pivot table in this tab. Large $ amounts (over $100 or so) are typically shown with zero decimals.
Ex3
| Group Segment | Revenue | Expenses | Member Months |
| Medium | 8249.3276698127 | 594.878242008 | 13 |
| Medium | 6557.8729832219 | 83.3393859721 | 9 |
| Small | 6180.0357471981 | 551.2667803915 | 51 |
| Medium | 9915.4543112251 | 336.8576784372 | 97 |
| Small | 4047.6691780881 | 481.0083008923 | 92 |
| Small | 4797.0875045761 | 962.3550943443 | 63 |
| Small | 6537.8001010167 | 931.9697247837 | 43 |
| Medium | 3151.4227753704 | 848.2135170178 | 64 |
| Big | 9504.7818270498 | 827.5632244434 | 28 |
| Medium | 9378.1404699585 | 566.7976536033 | 41 |
| Big | 6772.1330424373 | 436.8799836118 | 75 |
| Small | 1854.6321581898 | 930.5482506081 | 21 |
| Big | 8303.942664325 | 680.7503719864 | 13 |
| Small | 6741.4600639306 | 418.0317384718 | 96 |
| Small | 4151.4397576795 | 336.4056384211 | 20 |
| Small | 7972.3018907032 | 917.1406009069 | 43 |
| Big | 10331.5784748428 | 440.4744097264 | 94 |
| Small | 3695.1930207613 | 217.656286454 | 98 |
| Small | 7904.2936251937 | 764.5839324212 | 13 |
| Medium | 849.2599248439 | 94.5170366431 | 57 |
| Big | 7157.6275489008 | 915.9245386615 | 20 |
| Medium | 3712.5650123251 | 432.5485875 | 4 |
| Small | 7596.4395031012 | 134.8225879903 | 63 |
| Small | 2198.6577925002 | 1037.2944248302 | 13 |
| Big | 4723.9958751125 | 463.2899115583 | 84 |
| Medium | 1331.2645180153 | 959.230732332 | 39 |
| Medium | 2743.8026187562 | 222.9192618727 | 73 |
| Big | 5038.3068133744 | 306.9576869105 | 41 |
| Small | 10458.2660169081 | 692.7631083142 | 41 |
| Small | 7567.0351493276 | 720.319063955 | 6 |
| Big | 7688.4341585784 | 851.8513374504 | 100 |
| Small | 4023.2273803651 | 166.4942195963 | 38 |
| Medium | 4551.6036698894 | 701.0456588856 | 17 |
| Medium | 2665.1140925001 | 654.9796658203 | 97 |
| Small | 6589.1246624486 | 278.188383772 | 24 |
| Medium | 5220.4269398047 | 589.1737959411 | 90 |
| Medium | 7282.1887565894 | 387.5496207223 | 65 |
| Small | 6444.5836306461 | 258.5026825916 | 15 |
| Small | 10299.0292603392 | 287.8049257787 | 72 |
| Small | 9841.2295754339 | 824.4756791813 | 12 |
| Small | 8237.8478361811 | 48.295935834 | 87 |
| Medium | 6221.2486222635 | 414.8820747116 | 92 |
| Medium | 5401.2418187665 | 877.9679090344 | 90 |
| Small | 10013.8111744499 | 807.8507674011 | 60 |
| Big | 8466.6998122226 | 450.5696925698 | 71 |
| Small | 8382.2143021092 | 958.2511684014 | 51 |
| Small | 8105.417292176 | 647.6468244176 | 88 |
| Small | 10051.2553898009 | 1003.7298818404 | 36 |
| Small | 3667.2011903398 | 680.7146779199 | 96 |
| Small | 7822.0618391282 | 924.356296138 | 14 |
| Small | 4575.5271715324 | 657.6493200788 | 13 |
| Small | 3178.1969187318 | 756.2079622278 | 24 |
| Small | 1734.4124287934 | 864.1463818564 | 28 |
| Medium | 8601.0660961888 | 666.9245543096 | 24 |
| Medium | 8328.4456772697 | 898.709187836 | 88 |
| Medium | 9715.2700007066 | 536.2618534938 | 34 |
| Medium | 4722.7733516562 | 837.7133331881 | 6 |
| Medium | 3434.6941177052 | 574.1248994173 | 98 |
| Small | 8696.7559833849 | 581.4444768178 | 41 |
| Medium | 9195.0795951441 | 1000.6729727959 | 88 |
| Big | 4168.8717148103 | 650.9037445718 | 57 |
| Big | 885.2432428382 | 323.976885302 | 59 |
| Medium | 3222.2105426214 | 760.2840912571 | 32 |
| Small | 3185.1817433305 | 455.4647279589 | 99 |
| Small | 5050.9759276909 | 618.3260163369 | 27 |
| Small | 306.0780834123 | 275.3065373107 | 39 |
| Small | 9598.9767485102 | 613.291159948 | 90 |
| Small | 10338.8006490912 | 979.8520025153 | 57 |
| Medium | 7350.6122898348 | 271.9879435914 | 46 |
| Small | 7506.4726445372 | 408.0083325832 | 12 |
| Small | 1939.7810982667 | 413.9417923424 | 21 |
| Big | 7692.2168494089 | 1015.8743011635 | 40 |
| Big | 1060.4865464279 | 607.3436711671 | 31 |
| Medium | 738.5081579279 | 431.474943255 | 42 |
| Small | 8174.8391784214 | 206.6453096591 | 6 |
| Small | 4368.8062371314 | 203.3753446594 | 27 |
| Small | 1292.5195029237 | 123.1056275262 | 64 |
| Big | 2210.7487570109 | 465.5261878633 | 86 |
| Big | 4240.7446320371 | 737.0688535015 | 64 |
| Small | 5927.0420304617 | 501.2388428822 | 22 |
| Small | 2597.3536595969 | 489.9869776835 | 41 |
| Small | 9549.4868167864 | 835.0236504696 | 28 |
| Small | 3931.3343697968 | 191.4213294839 | 59 |
| Small | 8578.8035799992 | 670.2412285641 | 13 |
| Big | 1946.1366556306 | 273.5117357051 | 47 |
| Medium | 9021.0164310181 | 402.0587254044 | 72 |
| Medium | 5575.6717397643 | 148.3339740683 | 20 |
| Big | 1193.0661622927 | 148.1347430675 | 72 |
| Small | 10340.5333462744 | 250.0846509055 | 8 |
| Small | 5512.7676568329 | 542.6187225193 | 61 |
| Medium | 2555.9990671807 | 824.1294903511 | 93 |
| Small | 10157.8136696377 | 508.1698277468 | 63 |
| Medium | 8921.5218567564 | 259.3318537021 | 18 |
| Big | 10494.443301691 | 565.4318597359 | 81 |
| Medium | 7007.7682447152 | 765.6916987833 | 92 |
| Medium | 4811.0377530315 | 193.174936848 | 23 |
| Small | 8657.8271850026 | 171.6024125265 | 41 |
| Medium | 8204.3205994819 | 278.7477843631 | 97 |
| Small | 4246.8831914754 | 644.5164909708 | 22 |
Exercise 3 Make a pivot table showing each segments revenue and expenses. Make sure to use both row headers and column headers. Have "Sum of Member Months" be the left most column. Create a column adjacent to the pivot table that represents the Revenue and Expenses PMPM's. PMPM's are typically represented with dollar signs ($) and to two decimal places. Keep the table in this tab.
Ex4
| Subdivision | Group Segment | Revenue | Expenses |
| Bigger | Medium | 8249.3276698127 | 594.878242008 |
| Bigger | Medium | 6557.8729832219 | 83.3393859721 |
| Pretty Small | Small | 6180.0357471981 | 551.2667803915 |
| Bigger | Medium | 9915.4543112251 | 336.8576784372 |
| Very Small | Small | 4047.6691780881 | 481.0083008923 |
| Pretty Small | Small | 4797.0875045761 | 962.3550943443 |
| Pretty Small | Small | 6537.8001010167 | 931.9697247837 |
| Not as Big | Medium | 3151.4227753704 | 848.2135170178 |
| Not Real Big | Big | 9504.7818270498 | 827.5632244434 |
| Not as Big | Medium | 9378.1404699585 | 566.7976536033 |
| Not Real Big | Big | 6772.1330424373 | 436.8799836118 |
| Pretty Small | Small | 1854.6321581898 | 930.5482506081 |
| More than 500 | Big | 8303.942664325 | 680.7503719864 |
| Pretty Small | Small | 6741.4600639306 | 418.0317384718 |
| Very Small | Small | 4151.4397576795 | 336.4056384211 |
| Pretty Small | Small | 7972.3018907032 | 917.1406009069 |
| Not Real Big | Big | 10331.5784748428 | 440.4744097264 |
| Pretty Small | Small | 3695.1930207613 | 217.656286454 |
| Pretty Small | Small | 7904.2936251937 | 764.5839324212 |
| Bigger | Medium | 849.2599248439 | 94.5170366431 |
| More than 500 | Big | 7157.6275489008 | 915.9245386615 |
| Bigger | Medium | 3712.5650123251 | 432.5485875 |
| Very Small | Small | 7596.4395031012 | 134.8225879903 |
| Very Small | Small | 2198.6577925002 | 1037.2944248302 |
| Not Real Big | Big | 4723.9958751125 | 463.2899115583 |
| Bigger | Medium | 1331.2645180153 | 959.230732332 |
| Not as Big | Medium | 2743.8026187562 | 222.9192618727 |
| More than 500 | Big | 5038.3068133744 | 306.9576869105 |
| Very Small | Small | 10458.2660169081 | 692.7631083142 |
| Pretty Small | Small | 7567.0351493276 | 720.319063955 |
| More than 500 | Big | 7688.4341585784 | 851.8513374504 |
| Pretty Small | Small | 4023.2273803651 | 166.4942195963 |
| Not as Big | Medium | 4551.6036698894 | 701.0456588856 |
| Not as Big | Medium | 2665.1140925001 | 654.9796658203 |
| Very Small | Small | 6589.1246624486 | 278.188383772 |
| Not as Big | Medium | 5220.4269398047 | 589.1737959411 |
| Not as Big | Medium | 7282.1887565894 | 387.5496207223 |
| Pretty Small | Small | 6444.5836306461 | 258.5026825916 |
| Very Small | Small | 10299.0292603392 | 287.8049257787 |
| Pretty Small | Small | 9841.2295754339 | 824.4756791813 |
| Very Small | Small | 8237.8478361811 | 48.295935834 |
| Bigger | Medium | 6221.2486222635 | 414.8820747116 |
| Bigger | Medium | 5401.2418187665 | 877.9679090344 |
| Very Small | Small | 10013.8111744499 | 807.8507674011 |
| More than 500 | Big | 8466.6998122226 | 450.5696925698 |
| Pretty Small | Small | 8382.2143021092 | 958.2511684014 |
| Very Small | Small | 8105.417292176 | 647.6468244176 |
| Very Small | Small | 10051.2553898009 | 1003.7298818404 |
| Pretty Small | Small | 3667.2011903398 | 680.7146779199 |
| Pretty Small | Small | 7822.0618391282 | 924.356296138 |
| Very Small | Small | 4575.5271715324 | 657.6493200788 |
| Pretty Small | Small | 3178.1969187318 | 756.2079622278 |
| Pretty Small | Small | 1734.4124287934 | 864.1463818564 |
| Bigger | Medium | 8601.0660961888 | 666.9245543096 |
| Bigger | Medium | 8328.4456772697 | 898.709187836 |
| Not as Big | Medium | 9715.2700007066 | 536.2618534938 |
| Bigger | Medium | 4722.7733516562 | 837.7133331881 |
| Not as Big | Medium | 3434.6941177052 | 574.1248994173 |
| Very Small | Small | 8696.7559833849 | 581.4444768178 |
| Not as Big | Medium | 9195.0795951441 | 1000.6729727959 |
| Not Real Big | Big | 4168.8717148103 | 650.9037445718 |
| Not Real Big | Big | 885.2432428382 | 323.976885302 |
| Bigger | Medium | 3222.2105426214 | 760.2840912571 |
| Pretty Small | Small | 3185.1817433305 | 455.4647279589 |
| Pretty Small | Small | 5050.9759276909 | 618.3260163369 |
| Very Small | Small | 306.0780834123 | 275.3065373107 |
| Pretty Small | Small | 9598.9767485102 | 613.291159948 |
| Very Small | Small | 10338.8006490912 | 979.8520025153 |
| Bigger | Medium | 7350.6122898348 | 271.9879435914 |
| Very Small | Small | 7506.4726445372 | 408.0083325832 |
| Very Small | Small | 1939.7810982667 | 413.9417923424 |
| More than 500 | Big | 7692.2168494089 | 1015.8743011635 |
| Not Real Big | Big | 1060.4865464279 | 607.3436711671 |
| Bigger | Medium | 738.5081579279 | 431.474943255 |
| Very Small | Small | 8174.8391784214 | 206.6453096591 |
| Very Small | Small | 4368.8062371314 | 203.3753446594 |
| Pretty Small | Small | 1292.5195029237 | 123.1056275262 |
| More than 500 | Big | 2210.7487570109 | 465.5261878633 |
| Not Real Big | Big | 4240.7446320371 | 737.0688535015 |
| Very Small | Small | 5927.0420304617 | 501.2388428822 |
| Very Small | Small | 2597.3536595969 | 489.9869776835 |
| Very Small | Small | 9549.4868167864 | 835.0236504696 |
| Pretty Small | Small | 3931.3343697968 | 191.4213294839 |
| Pretty Small | Small | 8578.8035799992 | 670.2412285641 |
| More than 500 | Big | 1946.1366556306 | 273.5117357051 |
| Not as Big | Medium | 9021.0164310181 | 402.0587254044 |
| Not as Big | Medium | 5575.6717397643 | 148.3339740683 |
| More than 500 | Big | 1193.0661622927 | 148.1347430675 |
| Very Small | Small | 10340.5333462744 | 250.0846509055 |
| Very Small | Small | 5512.7676568329 | 542.6187225193 |
| Not as Big | Medium | 2555.9990671807 | 824.1294903511 |
| Pretty Small | Small | 10157.8136696377 | 508.1698277468 |
| Bigger | Medium | 8921.5218567564 | 259.3318537021 |
| More than 500 | Big | 10494.443301691 | 565.4318597359 |
| Bigger | Medium | 7007.7682447152 | 765.6916987833 |
| Not as Big | Medium | 4811.0377530315 | 193.174936848 |
| Pretty Small | Small | 8657.8271850026 | 171.6024125265 |
| Bigger | Medium | 8204.3205994819 | 278.7477843631 |
| Pretty Small | Small | 4246.8831914754 | 644.5164909708 |
Exercise 4 Create a column entitled "Net Income/Loss." This column will represent Revenue minus Expenses. Make a pivot table representing Each Segment and Subdivision by Revenue, Expenses, and Net Income. Use row headers and column headers. Keep pivot table in this tab.
Ex7
| Group Name | Group Segment | Revenue | Expenses | Net Income/Loss | Data | ||
| Postcards Store | Big | 8249.3276698127 | 594.878242008 | 7654.4494278048 | Group Segment | Sum of Expenses | Sum of Revenue |
| Randles Roadshack | Small | 6557.8729832219 | 83.3393859721 | 6474.5335972499 | Big | 41586390.9696846 | 48945091.5423439 |
| Examineers Inc | Medium | 6180.0357471981 | 551.2667803915 | 5628.7689668066 | Medium | 2310.7997296187 | 22222.6176752647 |
| Buttersworth Co | Small | 9915.4543112251 | 336.8576784372 | 9578.5966327879 | Small | 2186.2988659312 | 30444.5522903428 |
| FASST Trax | Small | 4047.6691780881 | 481.0083008923 | 3566.6608771959 | Grand Total | 41590888.0682801 | 48997758.7123095 |
| Hula Hoopers | Big | 4797.0875045761 | 962.3550943443 | 3834.7324102318 | |||
| Hehehe | Medium | 6537.8001010167 | 931.9697247837 | 5605.830376233 | |||
| Marleyville Tea | Small | 3151.4227753704 | 848.2135170178 | 2303.2092583526 | |||
| Creepy Lada | Medium | 9504.7818270498 | 827.5632244434 | 8677.2186026064 | |||
| Jokes R Us | Big | 9378.1404699585 | 566.7976536033 | 8811.3428163552 | |||
| Petie's Palace | Small | 6772.1330424373 | 436.8799836118 | 6335.2530588255 | |||
| Ramone's Castle | Big | 48922666.9867 | 41584266.9386946 | 7338400.04800493 |
Exercise 7 Because Ramone's Castle is a high outlier, take it out of the pivot table that is already done. Show Revenue and Expenses by Group Segment (excluding Ramone's Castle). Have "Sum of Revenue" be the left column (you may need to switch the two columns). Keep pivot table in this tab.
