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.
Table Subdivision | Group Segment | Revenue | Expenses | Bigger | Medium | 8249.328 | 594.8782 | Bigger | Medium | 6557.873 | 83.33939 | Pretty Small | Small | 6180.036 | 551.2668 | Bigger | Medium | 9915.454 | 336.8577 | Very Small | Small | 4047.669 | 481.0083 | Pretty Small | Small | 4797.088 | 962.3551 | Pretty Small | Small | 6537.8 | 931.9697 | Not as Big | Medium | 3151.423 | 848.2135 | Not Real Big | Big | 9504.782 | 827.5632 | Not as Big | Medium | 9378.14 | 566.7977 | Not Real Big | Big | 6772.133 | 436.88 | Pretty Small | Small | 1854.632 | 930.5483 | More than 500 | Big | 8303.943 | 680.7504 | Pretty Small | Small | 6741.46 | 418.0317 | Very Small | Small | 4151.44 | 336.4056 | Pretty Small | Small | 7972.302 | 917.1406 | Not Real Big | Big | 10331.58 | 440.4744 | Pretty Small | Small | 3695.193 | 217.6563 | Pretty Small | Small | 7904.294 | 764.5839 | Bigger | Medium | 849.2599 | 94.51704 | More than 500 | Big | 7157.628 | 915.9245 | Bigger | Medium | 3712.565 | 432.5486 | Very Small | Small | 7596.44 | 134.8226 | Very Small | Small | 2198.658 | 1037.294 | Not Real Big | Big | 4723.996 | 463.2899 | Bigger | Medium | 1331.265 | 959.2307 | Not as Big | Medium | 2743.803 | 222.9193 | More than 500 | Big | 5038.307 | 306.9577 | Very Small | Small | 10458.27 | 692.7631 | Pretty Small | Small | 7567.035 | 720.3191 | More than 500 | Big | 7688.434 | 851.8513 | Pretty Small | Small | 4023.227 | 166.4942 | Not as Big | Medium | 4551.604 | 701.0457 | Not as Big | Medium | 2665.114 | 654.9797 | Very Small | Small | 6589.125 | 278.1884 | Not as Big | Medium | 5220.427 | 589.1738 | Not as Big | Medium | 7282.189 | 387.5496 | Pretty Small | Small | 6444.584 | 258.5027 | Very Small | Small | 10299.03 | 287.8049 | Pretty Small | Small | 9841.23 | 824.4757 | Very Small | Small | 8237.848 | 48.29594 | Bigger | Medium | 6221.249 | 414.8821 | Bigger | Medium | 5401.242 | 877.9679 | Very Small | Small | 10013.81 | 807.8508 | More than 500 | Big | 8466.7 | 450.5697 | Pretty Small | Small | 8382.214 | 958.2512 | Very Small | Small | 8105.417 | 647.6468 | Very Small | Small | 10051.26 | 1003.73 | Pretty Small | Small | 3667.201 | 680.7147 | Pretty Small | Small | 7822.062 | 924.3563 | Very Small | Small | 4575.527 | 657.6493 | Pretty Small | Small | 3178.197 | 756.208 | Pretty Small | Small | 1734.412 | 864.1464 | Bigger | Medium | 8601.066 | 666.9246 | Bigger | Medium | 8328.446 | 898.7092 | Not as Big | Medium | 9715.27 | 536.2619 | Bigger | Medium | 4722.773 | 837.7133 | Not as Big | Medium | 3434.694 | 574.1249 | Very Small | Small | 8696.756 | 581.4445 | Not as Big | Medium | 9195.08 | 1000.673 | Not Real Big | Big | 4168.872 | 650.9037 | Not Real Big | Big | 885.2432 | 323.9769 | Bigger | Medium | 3222.211 | 760.2841 | Pretty Small | Small | 3185.182 | 455.4647 | Pretty Small | Small | 5050.976 | 618.326 | Very Small | Small | 306.0781 | 275.3065 | Pretty Small | Small | 9598.977 | 613.2912 | Very Small | Small | 10338.8 | 979.852 | Bigger | Medium | 7350.612 | 271.9879 | Very Small | Small | 7506.473 | 408.0083 | Very Small | Small | 1939.781 | 413.9418 | More than 500 | Big | 7692.217 | 1015.874 | Not Real Big | Big | 1060.487 | 607.3437 | Bigger | Medium | 738.5082 | 431.4749 | Very Small | Small | 8174.839 | 206.6453 | Very Small | Small | 4368.806 | 203.3753 | Pretty Small | Small | 1292.52 | 123.1056 | More than 500 | Big | 2210.749 | 465.5262 | Not Real Big | Big | 4240.745 | 737.0689 | Very Small | Small | 5927.042 | 501.2388 | Very Small | Small | 2597.354 | 489.987 | Very Small | Small | 9549.487 | 835.0237 | Pretty Small | Small | 3931.334 | 191.4213 | Pretty Small | Small | 8578.804 | 670.2412 | More than 500 | Big | 1946.137 | 273.5117 | Not as Big | Medium | 9021.016 | 402.0587 | Not as Big | Medium | 5575.672 | 148.334 | More than 500 | Big | 1193.066 | 148.1347 | Very Small | Small | 10340.53 | 250.0847 | Very Small | Small | 5512.768 | 542.6187 | Not as Big | Medium | 2555.999 | 824.1295 | Pretty Small | Small | 10157.81 | 508.1698 | Bigger | Medium | 8921.522 | 259.3319 | More than 500 | Big | 10494.44 | 565.4319 | Bigger | Medium | 7007.768 | 765.6917 | Not as Big | Medium | 4811.038 | 193.1749 | Pretty Small | Small | 8657.827 | 171.6024 | Bigger | Medium | 8204.321 | 278.7478 | Pretty Small | Small | 4246.883 | 644.5165 | | | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |