[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1217 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Allen, Rebecca, E,21787 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 | 0.00 |
| Sanchez, Meredith, S,19920 | 91.96 | 0.00 | 0.00 | 0.00 | 91.96 | 0.00 |
| Lewis, Michael, R,14782 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 | 0.00 |
| Parker, Edward, N,12938 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 | 0.00 |
| Collins, Amber, M,18963 | 589.98 | 0.00 | 0.00 | 0.00 | 589.98 | 0.00 |
| Perry, Samantha, F,24776 | 91.58 | 0.00 | 0.00 | 0.00 | 91.58 | 0.00 |
| Jai, Raul,21720 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 | 0.00 |
| Flores, Anna, H,18346 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 | 0.00 |
| Rivera, Cody, L,16887 | 1769.96 | 0.00 | 0.00 | 0.00 | 1769.96 | 0.00 |
| Torres, Joe, A,11816 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 | 0.00 |
| Alexander, Haley,11837 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 | 0.00 |
| Xie, Rafael, M,11326 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 | 0.00 |
| Suarez, Jay, C,11470 | 4344.09 | 0.00 | 2049.10 | 0.00 | 2294.99 | 0.00 |
| Nath, Wayne,12468 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 | 0.00 |
| Ortega, Craig,17383 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Sanz, Beth,14462 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 | 0.00 |
| Andersen, Kurt,15053 | 93.48 | 0.00 | 0.00 | 0.00 | 93.48 | 0.00 |
| Fernandez, Johnathan,25144 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 | 0.00 |
| Allen, Seth, M,12946 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 | 0.00 |
| Robinson, Isabella, P,20641 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 | 0.00 |
| Powell, Xavier,29238 | 4398.10 | 0.00 | 3578.27 | 0.00 | 819.83 | 0.00 |
| Raman, Barry, A,24783 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 | 0.00 |
| Ortega, Teresa, F,24791 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Hernandez, Stephanie, V,21235 | 1134.47 | 0.00 | 0.00 | 0.00 | 1134.47 | 0.00 |
| Peterson, Melanie,28094 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 | 0.00 |
| Jackson, Alexander, R,28793 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 | 0.00 |
| Ross, Sydney, T,11226 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 | 0.00 |
| Coleman, Grace, J,28032 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 | 0.00 |
| Scott, Gabriella, A,25378 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 | 0.00 |
| Diaz, Fernando, W,23711 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 | 0.00 |
| Washington, Jason,17137 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Deng, Mitchell,18150 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 | 0.00 |
| Deng, Nicolas, P,17738 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 | 0.00 |
| Ortega, Cheryl,11983 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 | 0.00 |
| Tang, Maurice, M,11160 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 | 0.00 |
| Luo, Jon,11298 | 5922.23 | 0.00 | 3578.27 | 0.00 | 2343.96 | 0.00 |
| Peterson, Taylor, P,26315 | 2825.43 | 0.00 | 0.00 | 2049.10 | 776.33 | 0.00 |
| Clark, Ashley, H,12398 | 2920.45 | 0.00 | 0.00 | 0.00 | 2920.45 | 0.00 |
| Sanchez, Alexandria, A,27644 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 | 0.00 |
| Price, Eduardo, W,22761 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 | 0.00 |
| Lopez, Dalton, W,20534 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 | 0.00 |
| Long, Abigail, F,22347 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 | 0.00 |
| Hall, Elijah, R,17266 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 | 0.00 |
| Kumar, Johnny, G,15740 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Moore, Emily, W,14350 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 | 0.00 |
| Rubio, Billy, L,21536 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 | 0.00 |
| Lal, Keith,19450 | 1887.56 | 0.00 | 699.10 | 0.00 | 1188.46 | 0.00 |
| Andersen, Cassie,14428 | 8321.31 | 0.00 | 3578.27 | 0.00 | 4743.04 | 0.00 |
| Coleman, Alyssa, C,15366 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 | 0.00 |
| Long, Logan,25098 | 1251.12 | 0.00 | 0.00 | 0.00 | 1251.12 | 0.00 |
| Price, Kaitlyn,22300 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 | 0.00 |
| Hayes, Miguel, K,29025 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 | 0.00 |
| Lin, Colin,11255 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 | 0.00 |
| Serrano, Juan,22334 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 | 0.00 |
| Sun, Amy, C,11421 | 9780.04 | 0.00 | 3399.99 | 0.00 | 6380.05 | 0.00 |
| Stewart, Jasmine,11423 | 9904.97 | 0.00 | 3374.99 | 0.00 | 6529.98 | 0.00 |
| Dominguez, Alberto, R,26078 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 | 0.00 |
| Adams, Maria, N,22734 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 | 0.00 |
| Simmons, Cameron, J,16777 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 | 0.00 |
| Bailey, Jade, E,11319 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 | 0.00 |
| Clark, Chloe, K,24340 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Zhang, Austin,19395 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 | 0.00 |
Generated 2026-01-04 05:38:17.803 UTC