Use of Excel Pivot Tables
clis12
CustomerRevenues.xlsx
customerrevenues
| customer title | state | order date | ID | ordervolume | location | ordervolume USD | customer category |
| Firma AA | NV | 1/15/06 | 27 | 1,400.00 € |
| Firma AA | NV | 1/15/06 | 28 | 105.00 € |
| Firma D | NY | 1/20/06 | 29 | 300.00 € |
| Firma D | NY | 1/20/06 | 30 | 530.00 € |
| Firma D | NY | 1/20/06 | 31 | 35.00 € |
| Firma L | NV | 1/22/06 | 32 | 270.00 € |
| Firma L | NV | 1/22/06 | 33 | 920.00 € |
| Firma H | OR | 1/30/06 | 34 | 276.00 € |
| Firma D | NY | 2/6/06 | 35 | 184.00 € |
| Firma CC | CO | 2/10/06 | 36 | 127.50 € |
| Firma C | CA | 2/23/06 | 37 | 1,930.00 € |
| Firma F | WI | 3/6/06 | 38 | 680.00 € |
| Firma BB | TN | 3/10/06 | 39 | 13,800.00 € |
| Firma H | OR | 3/22/06 | 40 | 1,275.00 € |
| Firma J | IL | 3/24/06 | 41 | 598.00 € |
| Firma G | ID | 3/24/06 | 42 | 13,800.00 € |
| Firma J | IL | 3/24/06 | 43 | 250.00 € |
| Firma J | IL | 3/24/06 | 44 | 220.00 € |
| Firma J | IL | 3/24/06 | 45 | 92.00 € |
| Firma K | FL | 3/24/06 | 46 | 70.00 € |
| Firma K | FL | 3/24/06 | 47 | 149.50 € |
| Firma A | WA | 3/24/06 | 48 | 450.00 € |
| Firma A | WA | 3/24/06 | 50 | 74.75 € |
| Firma BB | TN | 4/7/06 | 51 | 482.50 € |
| Firma BB | TN | 4/7/06 | 52 | 920.00 € |
| Firma I | UT | 4/5/06 | 53 | 1,950.00 € |
| Firma I | UT | 4/5/06 | 54 | 1,740.00 € |
| Firma F | WI | 4/8/06 | 55 | 4,200.00 € |
| Firma H | OR | 4/5/06 | 56 | 1,000.00 € |
| Firma H | OR | 4/5/06 | 57 | 230.00 € |
| Firma Y | IL | 4/5/06 | 59 | 200.00 € |
| Firma Z | FL | 4/5/06 | 60 | 533.75 € |
| Firma Z | FL | 4/5/06 | 61 | 289.50 € |
| Firma Z | FL | 4/5/06 | 62 | 552.00 € |
| Firma CC | CO | 4/5/06 | 67 | 1,218.00 € |
| Firma F | WI | 4/3/06 | 66 | 127.50 € |
| Firma AA | NV | 4/22/06 | 96 | 3,240.00 € |
| Firma D | NY | 4/22/06 | 84 | 3,240.00 € |
| Firma D | NY | 4/22/06 | 85 | 280.00 € |
| Firma D | NY | 4/22/06 | 92 | 280.00 € |
| Firma L | NV | 4/22/06 | 98 | 900.00 € |
| Firma H | OR | 4/30/06 | 81 | 1,392.00 € |
| Firma D | NY | 4/7/06 | 91 | 760.00 € |
| Firma CC | CO | 4/12/06 | 49 | 1,150.00 € |
| Firma C | CA | 4/25/06 | 82 | 500.00 € |
| Firma F | WI | 5/9/06 | 95 | 3,240.00 € |
| Firma BB | TN | 5/11/06 | 93 | 3,240.00 € |
| Firma H | OR | 5/24/06 | 79 | 52.50 € |
| Firma J | IL | 5/24/06 | 80 | 200.00 € |
| Firma G | ID | 5/24/06 | 83 | 120.00 € |
| Firma J | IL | 5/24/06 | 86 | 52.50 € |
| Firma K | FL | 5/24/06 | 78 | 800.00 € |
| Firma A | WA | 5/24/06 | 77 | 736.00 € |
| Firma BB | TN | 6/7/06 | 76 | 230.00 € |
| Firma I | UT | 6/5/06 | 75 | 96.50 € |
| Firma F | WI | 6/8/06 | 74 | 510.00 € |
| Firma H | OR | 6/5/06 | 73 | 510.00 € |
| Firma Y | IL | 6/5/06 | 72 | 660.00 € |
| Firma Z | FL | 6/5/06 | 71 | 2,250.00 € |
| Firma CC | CO | 6/5/06 | 70 | 1,560.00 € |
| Firma F | WI | 6/23/06 | 68 | 900.00 € |
| Firma F | WI | 6/23/06 | 69 | 1,590.00 € |
| Firma D | NY | 4/25/06 | 97 | 3,240.00 € |
| Firma C | CA | 4/25/06 | 90 | 38.87 € |
| | | | | total order volume : |
| | | | | largest order item : |
| | | | | smallest order item |
| | | | | average order volume : |
deliveryareas
| | | | idnr | state | location |
| | | | 10 | CA | Southwest |
| | | | 20 | CO | Southwest |
| | | | 30 | FL | South |
| | | | 40 | ID | Midwest |
| | | | 50 | IL | Midwest |
| | | | 60 | NV | Southwest |
| | | | 70 | NY | East |
| | | | 80 | OR | Midwest |
| | | | 90 | TN | South |
| | | | 100 | UT | Midwest |
| | | | 110 | WA | East |
| | | | 120 | WI | Midwest |
USD
| | EURO | 1.00 € | = | 1.11 [$USD] | US Dollar |
customercategories
| | | ident-nr | steps | categories |
| | | KK-0 | 0 | D |
| | | KK-1 | 200 | C |
| | | KK-2 | 1500 | B |
| | | KK-3 | 3000 | A |
