Spreadsheet: 168904d1342626985-sorting-pivot-tables-by-grand-total-column-in-excel-2010-help
Sheet: Pivot (2)

Period | (All)
Fiscal Year | 2012
Sum of $$ |  |  | Cost element name
Name | Position | Division/Region | T&E-Other | T&E-Mileage | T&E-Meal&Entertain | T&E-Lodging | T&E-Employee Meals | T&E-Airfare | Grand Total
ABRAHAM, KAREN | DHRM | Pac South | 202.42 | 2319.2 | 133.7 | 373.12 |  | 1690.67 | 4719.110000000001
AKONOM, [NAME] | APM | [NAME] | 717.15 | 1123.999999999999 | 32.97 |  |  | 728.36 | 2602.479999999999
ALBANO, BRIAN M | OPS ASST MGR | Western Division |  |  |  |  |  | 25 | 25
ALEXANDER, STEVEN | RDO | [NAME] | 2900.13 | 1709.2 | 2798.260000000001 | 4148.929999999999 |  | 6625.590000000003 | 18182.11
ALEXANDER, VAN | DOM | Pac North | 27 | 1532.400000000001 |  | 107.91 |  | 3.1 | 1670.410000000001
ALI, EFRAN | APM | Pac North |  | 222.4 |  |  |  |  | 222.4
ALLEN, FRED | DI | Pac North | 7 | 1672.4 | 117.75 | 286.77 | 10 | 698.06 | 2791.98
ALVAREZ, [NAME] | DM | Western Division |  |  |  |  |  | 2.842170943040401e-14 | 2.842170943040401e-14
ALVAREZ, [NAME] | DM | Pac South |  |  |  |  |  | 125 | 125
ALVAREZ, [NAME] | DM | Pac North | 580.4 | 2102.799999999999 | 583.18 | 848.0300000000001 |  | 356.21 | 4470.619999999999
ALVAREZ, VIVIANN | APM | Pac South | 30 | 1149.200000000001 |  |  |  |  | 1179.200000000001
ALVORD, JAKE | DI | Pac North | 373 | 1364.4 | 405.9899999999999 | 1240.96 |  | 3384.64 | 6768.99
AMBROSIUS, MINDY | ADMIN ASST | Pac Central |  | 29.4 |  |  |  |  | 29.4
ANDERSEN, [NAME] | DHRM | Pac North | 1105.85 | 1144.4 | 463.9900000000001 | 1298.86 |  | 981.4 | 4994.499999999999
ANGULO, [NAME] | APM | Pac Central |  |  |  |  |  | 571.02 | 571.02
ARAGON, [NAME] | APM | [NAME] |  | 2026 |  |  |  |  | 2026
ARMSTRONG, RAY | APM | Pac Central |  | 448.6000000000001 |  |  |  |  | 448.6000000000001
ASTORINO, [NAME] | DM | Pac South |  | 1525.199999999999 | 296.87 |  |  |  | 1822.069999999999
ATILANO, EVERETT | DEPT SUPERVISOR | Pac South |  | 58.8 |  |  |  |  | 58.8
AVILA, SARA | ADMIN ASST | Pac Central |  | 130.4 |  |  |  |  | 130.4
BAKKEDAHL, SHAUNA | DHRM | Pac North | 961.6099999999999 | 2209.2 | 137.34 | 634.3 |  | 15.5 | 3957.950000000001
BALL, [NAME] | STORE MGR | Western Division |  |  |  |  |  | 390.6 | 390.6
BALL, JENNIPHER | DOM | [NAME] | 135.42 | 1104.8 | 146.3 | 206.99 |  | 386.6 | 1980.11
BANASZEK, ANTHONY | RECEIVING SUPERVISOR | Pac South |  |  |  |  |  | 1391.7 | 1391.7
BANUELOS, RUBEN | CI | Pac Central | 175.77 | 455.2 | 54.26 | 197.14 |  | 19.3 | 901.67
BARDALES, TOMAS | APM | Pac South |  | 1620 |  |  |  |  | 1620
BARRY, CHAD | APM | [NAME] | 1732.84 | 960.8000000000003 | 744.66 | 1198.11 |  | 40.30000000000001 | 4676.71
BATES, TRAVIS | DOM | Pac North | 223.24 | 3356.400000000002 | 238.88 | 693.0400000000001 |  | 365.1000000000001 | 4876.660000000003
BAYER, [NAME] | RDO | Pac Central | 150 | 412 | 1091.05 | 1075.66 |  | 877.6000000000003 | 3606.31
BEARDEN, STACIE | DM | [NAME] | 578.12 | 1453.6 | 1005.55 | 5521.690000000001 |  | 5699.030000000001 | 14257.99
BEAUBIEN, ROBERT | APM | [NAME] |  | 1030.799999999999 | 82.47 |  |  |  | 1113.27
BECK, [NAME] | SPECIALTY ASM | Western Division |  |  |  |  |  | 1563.53 | 1563.53
BECKLER, [NAME] | DI | Pac North | 44 | 1637.200000000001 | 191.43 | 90.77 |  | 1143.5 | 3106.900000000001
BEST, [NAME] | ASST STORE MGR | Western Division |  |  |  |  |  | 287.4 | 287.4
BETTS, BRAD | DIST ASST | [NAME] |  | 104 |  |  |  |  | 104
BEVER, DAMON | DI | Pac Central | 27 | 2869.199999999999 | 112.35 | 609.19 |  | 1332.48 | 4950.219999999999
BIDON, DINEEN | ADMIN ASST | Western Division |  |  |  |  |  | 0 | 0
BIRD, SUSAN | STORE MGR | [NAME] |  |  |  |  |  | 0 | 0
BLEEM, JOSHUA | STORE MGR | Pac North | 66 | 296.8 | 12 |  |  |  | 374.8
BOLEN, LISA | DHRM ASST | Pac North | 127.35 | 9.6 | 56.66 | 233.06 |  | 435.6 | 862.27
BOLTON, RICHARD | DM | [NAME] | 132.96 | 1512.4 | 56.53 | 276.38 |  | 424.6 | 2402.87
BOUDET, JUDI | ADMIN ASST | Western Division |  | 8.8 |  |  |  |  | 8.8
BOYER, TYSON | DHRM | Pac North | 199.33 | 1874.400000000001 | 10.59 | 864.55 |  | 1404.9 | 4353.77
BREMER, ADAM | STORE MGR | Western Division |  |  |  |  |  | 358.6 | 358.6
BROOKS, [NAME] | DM | Pac Central | 1654 | 2595.2 |  | 139.41 |  | 3.1 | 4391.710000000001
BROWN, [NAME] | DHRM | Pac Central | 15 | 674.8 |  |  |  |  | 689.8
BROWN, CLAYTON | DM | [NAME] | 338.26 | 1090.4 | 30 |  |  | 50 | 1508.66
BRUMFIELD, CAROLYN | DHRM | Pac North |  |  |  |  |  | 25 | 25
BRUNETTI, CHRIS | APM | Pac North |  | 236 | 13 | 118.13 |  |  | 367.13
BRUNING, ANGELA | DHRM | [NAME] | 270.17 | 1155.6 | 107.48 | 381.22 |  | 579.2 | 2493.67
BUI, PHUONG | ADMIN ASST | Pac Central | 27 | 56.46 |  |  |  |  | 83.46000000000001
BURTON, KEVIN | DHRM | [NAME] | 3737.429999999999 |  | 600.4800000000001 | 2341.39 |  | 685.78 | 7365.079999999999
BUYERS, MELISSA | ADMIN ASST | Western Division |  |  |  |  |  | 0 | 0
Grand Total |  |  | 16538.45 | 45282.46 | 9523.74 | 22885.61 | 10 | 32668.46999999999 | 126908.73