[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1125 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Powell, Kelly, L,14636 | 1538.58 | 0.00 | 699.10 | 0.00 | 839.48 | 0.00 |
| Mr., Adams, Ben,28678 | 4337.56 | 0.00 | 3578.27 | 0.00 | 759.29 | 0.00 |
| Bailey, Katelyn, C,28618 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Wang, Robert, B,13236 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 | 0.00 |
| Sandberg, Emma, J,14616 | 1538.58 | 0.00 | 699.10 | 0.00 | 839.48 | 0.00 |
| Griffin, Logan,28625 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Nara, Jodi, N,23939 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 | 0.00 |
| She, Jodi,22727 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 | 0.00 |
| Blue, Lauren,18890 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 | 0.00 |
| Shen, Ashlee, C,16566 | 5806.35 | 0.00 | 0.00 | 2181.56 | 3624.79 | 0.00 |
| Nelson, Seth,22729 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 | 0.00 |
| Arun, Holly,27154 | 1228.83 | 0.00 | 0.00 | 0.00 | 1228.83 | 0.00 |
| Roberts, Allison, M,29011 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 | 0.00 |
| Fernandez, Barry, B,20271 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 | 0.00 |
| Sanchez, Tina,27527 | 4514.97 | 0.00 | 0.00 | 2071.42 | 2443.55 | 0.00 |
| Carlson, Hector,28997 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Alonso, Robyn, C,17800 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 | 0.00 |
| Alonso, Jon,25952 | 4598.83 | 0.00 | 3374.99 | 0.00 | 1223.84 | 0.00 |
| Sutton, Tara, A,25633 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 | 0.00 |
| Johnson, Matthew,28857 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Ross, Emma,18350 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 | 0.00 |
| Arthur, Jarrod, R,27314 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Walker, Joseph, E,18226 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 | 0.00 |
| Thomas, Andrew, C,29004 | 4320.62 | 0.00 | 3578.27 | 0.00 | 742.35 | 0.00 |
| Liu, Valerie, R,24121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 | 0.00 |
| Murphy, Andrea, R,28828 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 | 0.00 |
| Martin, Megan, A,11737 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 | 0.00 |
| Dominguez, Desiree, S,11427 | 9917.99 | 0.00 | 3399.99 | 0.00 | 6518.00 | 0.00 |
| Bryant, Caroline, L,29136 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Xu, Wayne, M,18014 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 | 0.00 |
| Gill, Lance,12614 | 5918.24 | 0.00 | 3578.27 | 0.00 | 2339.97 | 0.00 |
| Ross, Jasmine, S,28838 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Xie, Donna,12549 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 | 0.00 |
| Anand, Shaun,25524 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 | 0.00 |
| Schmidt, Stanley, C,19035 | 3320.43 | 0.00 | 0.00 | 1000.44 | 2319.99 | 0.00 |
| Henderson, Taylor, M,19051 | 3104.57 | 0.00 | 699.10 | 0.00 | 2405.47 | 0.00 |
| Romero, Hector, E,25299 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Vance, Pedro, A,11499 | 192.21 | 0.00 | 0.00 | 0.00 | 192.21 | 0.00 |
| Parker, Jason, F,25969 | 4649.83 | 0.00 | 3399.99 | 0.00 | 1249.84 | 0.00 |
| Nelson, Caleb,22716 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 | 0.00 |
| Long, Gabriel,29017 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Lewis, Ashley, L,12960 | 51.27 | 0.00 | 0.00 | 0.00 | 51.27 | 0.00 |
| Cox, Carlos, L,20480 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Smith, Matthew, J,28830 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Cook, Chloe, L,26790 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 | 0.00 |
| Kelly, Mariah, L,19111 | 609.95 | 0.00 | 0.00 | 0.00 | 609.95 | 0.00 |
| She, Edwin,27417 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 | 0.00 |
| Cai, Micah,28859 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 | 0.00 |
| Phillips, Jesse,24514 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 | 0.00 |
| Cox, Sean, J,26086 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 | 0.00 |
| Patterson, Zachary, R,13993 | 1804.92 | 0.00 | 1000.44 | 0.00 | 804.48 | 0.00 |
| Hernandez, Pedro,21905 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 | 0.00 |
| Clark, Alyssa, J,18347 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Luo, Russell, S,14652 | 1528.07 | 0.00 | 699.10 | 0.00 | 828.97 | 0.00 |
| Cook, Brianna, E,29132 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Walker, Morgan, C,28854 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 | 0.00 |
| Yang, Brandon,24351 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Gonzales, Samuel,28841 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 | 0.00 |
| Prasad, Andre,27307 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Perry, Jocelyn, O,29059 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Nara, Nichole,12301 | 9717.11 | 0.00 | 0.00 | 2482.23 | 7234.88 | 0.00 |
| Xu, Krystal,25491 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
Generated 2026-01-04 08:52:22.731 UTC