Spreadsheet: 54548d1254523850-add-fields-in-a-pivot-54534d1254514776-trying-to-add-fields-in-a-pivot-sample-v2
Sheet: Pivot Table

 |  |  |  |  |  | Data
Account Owner | Opportunity Owner | Account Name | Product Category | Opportunity Type | Sales Stage | Sum of 1X - One-Time Revenue | Sum of BIE Revenue
alan_woller | alan_woller | Freedom Doors | [NAME] | New | Quote | 0 | 5331.5
 |  |  |  | New Total |  | 0 | 5331.5
 |  |  | MHC Network Total |  |  | 0 | 5331.5
 |  | Freedom Doors Total |  |  |  | 0 | 5331.5
 |  | Topsource Corporation | [NAME] | New | Quote | 0 | 2051.5
 |  |  |  | New Total |  | 0 | 2051.5
 |  |  | MHC Network Total |  |  | 0 | 2051.5
 |  | Topsource Corporation Total |  |  |  | 0 | 2051.5
 | alan_woller Total |  |  |  |  | 0 | 7383
alan_woller Total |  |  |  |  |  | 0 | 7383
brian_simon | brian_simon | Grace Construction Products | MHC Analytics | Renewal | Closed/Won | 0 | 2041.95
 |  |  |  | Renewal Total |  | 0 | 2041.95
 |  |  | MHC Analytics Total |  |  | 0 | 2041.95
 |  | Grace Construction Products Total |  |  |  | 0 | 2041.95
 | brian_simon Total |  |  |  |  | 0 | 2041.95
brian_simon Total |  |  |  |  |  | 0 | 2041.95
charlie_foti | charlie_foti | PGT IND | MHC Analytics | Mortal | Closed/Won | 0 | -17455.42
 |  |  |  | Mortal Total |  | 0 | -17455.42
 |  |  | MHC Analytics Total |  |  | 0 | -17455.42
 |  | PGT IND Total |  |  |  | 0 | -17455.42
 | charlie_foti Total |  |  |  |  | 0 | -17455.42
charlie_foti Total |  |  |  |  |  | 0 | -17455.42
daniel_ritz | daniel_ritz | Saniglaze | [NAME] | Mortal | Closed/Won | 0 | -24528
 |  |  |  | Mortal Total |  | 0 | -24528
 |  |  | MHC Network Total |  |  | 0 | -24528
 |  | Saniglaze Total |  |  |  | 0 | -24528
 | daniel_ritz Total |  |  |  |  | 0 | -24528
daniel_ritz Total |  |  |  |  |  | 0 | -24528
ethan_manley | ethan_manley | Awntek | [NAME] | Revision | Closed/Won | 0 | -9400
 |  |  |  | Revision Total |  | 0 | -9400
 |  |  | MHC Network Total |  |  | 0 | -9400
 |  | Awntek Total |  |  |  | 0 | -9400
 | ethan_manley Total |  |  |  |  | 0 | -9400
ethan_manley Total |  |  |  |  |  | 0 | -9400
john_vigne | chris_ramsey | Dietrich Industries, Inc. | MHC Analytics | Revision | Quote | 0 | 7800
 |  |  |  | Revision Total |  | 0 | 7800
 |  |  | MHC Analytics Total |  |  | 0 | 7800
 |  | Dietrich Industries, Inc. Total |  |  |  | 0 | 7800
 |  | Overly Manufacturing Co | MHC Analytics | Revision | Quote | 0 | 30000
 |  |  |  | Revision Total |  | 0 | 30000
 |  |  | MHC Analytics Total |  |  | 0 | 30000
 |  | Overly Manufacturing Co Total |  |  |  | 0 | 30000
 | chris_ramsey Total |  |  |  |  | 0 | 37800
john_vigne Total |  |  |  |  |  | 0 | 37800
karl_krutzky | karl_krutzky | ArtUSA Noise Control Products, Inc. | MHC Analytics | New | Quote | 0 | 5001
 |  |  |  | New Total |  | 0 | 5001
 |  |  | MHC Analytics Total |  |  | 0 | 5001
 |  | ArtUSA Noise Control Products, Inc. Total |  |  |  | 0 | 5001
 | karl_krutzky Total |  |  |  |  | 0 | 5001
karl_krutzky Total |  |  |  |  |  | 0 | 5001
keven_mccook | keven_mccook | INVISTA | MHC Analytics | Add A Brand | Proposal | 0 | 51862
 |  |  |  | Add A Brand Total |  | 0 | 51862
 |  |  | MHC Analytics Total |  |  | 0 | 51862
 |  | INVISTA Total |  |  |  | 0 | 51862
 |  | PROMETHEUM CEU | MHC Analytics | New | Proposal | 0 | 52000
 |  |  |  | New Total |  | 0 | 52000
 |  |  | MHC Analytics Total |  |  | 0 | 52000
 |  | PROMETHEUM CEU Total |  |  |  | 0 | 52000
 | keven_mccook Total |  |  |  |  | 0 | 103862
keven_mccook Total |  |  |  |  |  | 0 | 103862
pat_keck | alan_woller | Arundel Signs | [NAME] | New | Quote | 0 | 5500
 |  |  |  | New Total |  | 0 | 5500
 |  |  | MHC Network Total |  |  | 0 | 5500
 |  | Arundel Signs Total |  |  |  | 0 | 5500
 |  | POR-15 | [NAME] | New | Quote | 0 | 6897.5
 |  |  |  | New Total |  | 0 | 6897.5
 |  |  | MHC Network Total |  |  | 0 | 6897.5
 |  | POR-15 Total |  |  |  | 0 | 6897.5
 |  | Shenandoah Decorative Iron Works | [NAME] | New | Quote | 0 | 4153
 |  |  |  | New Total |  | 0 | 4153
 |  |  | MHC Network Total |  |  | 0 | 4153
 |  | Shenandoah Decorative Iron Works Total |  |  |  | 0 | 4153
 | alan_woller Total |  |  |  |  | 0 | 16550.5
pat_keck Total |  |  |  |  |  | 0 | 16550.5
reginald_lorjuste | reginald_lorjuste | Baldwin Hardware Corp | MHC Analytics | Revision | Quote | 0 | 3144
 |  |  |  | Revision Total |  | 0 | 3144
 |  |  | MHC Analytics Total |  |  | 0 | 3144
 |  | Baldwin Hardware Corp Total |  |  |  | 0 | 3144
 |  | LEHIGH ELECTRIC PRODUCTS | MHC Analytics | Renewal | Quote | 0 | 897
 |  |  |  | Renewal Total |  | 0 | 897
 |  |  | MHC Analytics Total |  |  | 0 | 897
 |  | LEHIGH ELECTRIC PRODUCTS Total |  |  |  | 0 | 897
 | reginald_lorjuste Total |  |  |  |  | 0 | 4041
reginald_lorjuste Total |  |  |  |  |  | 0 | 4041
[NAME] | [NAME] | Wilsonart International Inc | MHC Analytics | Add A Brand | Quote | 0 | 15000
 |  |  |  | Add A Brand Total |  | 0 | 15000
 |  |  | MHC Analytics Total |  |  | 0 | 15000
 |  | Wilsonart International Inc Total |  |  |  | 0 | 15000
 | robert_coltrin Total |  |  |  |  | 0 | 15000
robert_coltrin Total |  |  |  |  |  | 0 | 15000
rochelle_staiano | alan_woller | West Chester Modular Co | [NAME] | New | Quote | 0 | 7500
 |  |  |  | New Total |  | 0 | 7500
 |  |  | MHC Network Total |  |  | 0 | 7500
 |  | West Chester Modular Co Total |  |  |  | 0 | 7500
 | alan_woller Total |  |  |  |  | 0 | 7500
rochelle_staiano Total |  |  |  |  |  | 0 | 7500
scott_stooksberry | [NAME] | Crossville Ceramics | MHC Dodge | Revision | Closed/Won | 0 | -8571.66
 |  |  |  | Revision Total |  | 0 | -8571.66
 |  |  | MHC Dodge Total |  |  | 0 | -8571.66
 |  | Crossville Ceramics Total |  |  |  | 0 | -8571.66
 | robert_coltrin Total |  |  |  |  | 0 | -8571.66
 | scott_stooksberry | Echo Bridge South | MHC Analytics | Revision | Quote | 0 | 2472.17
 |  |  |  | Revision Total |  | 0 | 2472.17
 |  |  | MHC Analytics Total |  |  | 0 | 2472.17
 |  | Echo Bridge South Total |  |  |  | 0 | 2472.17
 |  | Sanderson Plumbing Products | MHC Analytics | New | Quote | 0 | 20000
 |  |  |  | New Total |  | 0 | 20000
 |  |  | MHC Analytics Total |  |  | 0 | 20000
 |  | Sanderson Plumbing Products Total |  |  |  | 0 | 20000
 | scott_stooksberry Total |  |  |  |  | 0 | 22472.17
scott_stooksberry Total |  |  |  |  |  | 0 | 13900.51
tom_twomey | tom_twomey | Kingspan/Tate Access Floors | MHC Analytics | Revision | Proposal | 0 | 80000
 |  |  |  | Revision Total |  | 0 | 80000
 |  |  | MHC Analytics Total |  |  | 0 | 80000
 |  | Kingspan/Tate Access Floors Total |  |  |  | 0 | 80000
 |  | Tate Access Floors | MHC Analytics | Revision | Proposal | 0 | -27600
 |  |  |  | Revision Total |  | 0 | -27600
 |  |  | MHC Analytics Total |  |  | 0 | -27600
 |  | Tate Access Floors Total |  |  |  | 0 | -27600
 | tom_twomey Total |  |  |  |  | 0 | 52400
tom_twomey Total |  |  |  |  |  | 0 | 52400
Grand Total |  |  |  |  |  | 0 | 214096.54