[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 75 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raman, Stefanie,14424 | 6998.86 | 0.00 | 0.00 | 2181.56 | 4817.30 |
| Cox, Kaitlyn,13306 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| He, Alvin,25490 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lee, Emma,16948 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Ray, Regina, B,25142 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Russell, Alexia,19742 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Smith, Joseph, T,20513 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Watson, Melanie, C,27048 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Romero, Kristi, D,16965 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhang, Leah,28540 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Zeng, Susan,16825 | 61.45 | 0.00 | 0.00 | 0.00 | 61.45 |
| She, Bethany,12823 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Morgan, Bailey,24451 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Subram, Harold, D,23903 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Flores, Melissa,23687 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Jackson, Thomas, J,20368 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Perry, Mya,28739 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Baker, Miguel, M,14824 | 4441.25 | 0.00 | 3578.27 | 0.00 | 862.98 |
| Moreno, Stacy,26513 | 2848.76 | 0.00 | 0.00 | 2071.42 | 777.34 |
| Hill, Devin,19660 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Coleman, Victoria, O,23708 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Allen, Jennifer,27106 | 4455.49 | 0.00 | 0.00 | 2071.42 | 2384.07 |
| Hayes, Paige,16002 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Shan, Caleb, A,15467 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Thomas, Joseph, P,27989 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Green, Andrea,21326 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Foster, Jason, A,12934 | 4551.53 | 0.00 | 2181.56 | 0.00 | 2369.97 |
| Malhotra, Virginia,23758 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Walker, Taylor,21740 | 131.44 | 0.00 | 0.00 | 0.00 | 131.44 |
| Barnes, Melanie, M,29073 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gomez, Shannon,17854 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Blue, Morgan, A,13056 | 3291.82 | 0.00 | 2443.35 | 0.00 | 848.47 |
| James, Danielle,12978 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Liang, Leah,16412 | 4921.59 | 0.00 | 0.00 | 2443.35 | 2478.24 |
| Diaz, Alberto, A,14174 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Sanders, Juan, W,20432 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Howard, Lucas, A,13721 | 2786.52 | 0.00 | 0.00 | 2181.56 | 604.96 |
| Simmons, Alexis,23849 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Gomez, Orlando,29353 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Johnston, Shannon, L,20587 | 2378.95 | 0.00 | 0.00 | 0.00 | 2378.95 |
| Zhou, Susan,15678 | 7223.34 | 0.00 | 0.00 | 2443.35 | 4779.99 |
| Johnson, Anna,28126 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Arthur, Jermaine, H,20751 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Foster, Jennifer,13029 | 2961.04 | 0.00 | 2181.56 | 0.00 | 779.48 |
| Yuan, Wayne, V,17088 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Foster, Luis, R,26009 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Rodriguez, Elizabeth, J,18129 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Zhang, Jason, L,12796 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Torres, Gerald, M,26954 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 |
| Thompson, Robert, R,21065 | 1549.11 | 0.00 | 0.00 | 0.00 | 1549.11 |
| Perry, Spencer,23808 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Peterson, Faith,28593 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Simmons, Seth, E,14283 | 1799.92 | 0.00 | 0.00 | 1000.44 | 799.48 |
| Pal, Tommy,13840 | 3010.03 | 0.00 | 0.00 | 2181.56 | 828.47 |
| Bryant, Stephanie, V,20634 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Garcia, Jennifer,15307 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Foster, Benjamin, D,27680 | 35.72 | 0.00 | 0.00 | 0.00 | 35.72 |
| Alvarez, Jaime, C,28058 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Roberts, Mason, D,11176 | 213.33 | 0.00 | 0.00 | 0.00 | 213.33 |
| Watson, Chloe, O,19293 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
Generated 2025-12-21 20:42:06.854 UTC