[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lal, Alison,27812 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, Deborah, E,13502 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Peterson, Faith,28593 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Cai, Erica,22816 | 2340.94 | 0.00 | 0.00 | 0.00 | 2340.94 |
| Jackson, Dalton,28125 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bryant, Julian, A,28679 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Coleman, Carson,21493 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| White, Victoria, J,15867 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hernandez, Eddie, I,28464 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Jordan, Gerald, L,19053 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Madan, Cesar, E,11608 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Diaz, Albert, A,12436 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Robinson, Wyatt,19659 | 557.26 | 0.00 | 0.00 | 0.00 | 557.26 |
| Ruiz, Robyn, I,13894 | 4810.29 | 0.00 | 0.00 | 2443.35 | 2366.94 |
| Gonzales, Mya,11516 | 5915.54 | 0.00 | 3578.27 | 0.00 | 2337.27 |
| Ortega, Roberto, R,28382 | 786.33 | 0.00 | 0.00 | 0.00 | 786.33 |
| Gonzalez, Toni, E,26575 | 2890.41 | 0.00 | 0.00 | 2049.10 | 841.31 |
| Wood, Eduardo, E,29138 | 4374.61 | 0.00 | 3578.27 | 0.00 | 796.34 |
| Romero, Pedro,17123 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Garcia, Jasmine, A,22297 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| King, Noah,25876 | 4629.07 | 3374.99 | 0.00 | 0.00 | 1254.08 |
| Munoz, Reginald, C,25889 | 4651.11 | 3399.99 | 0.00 | 0.00 | 1251.12 |
| Williams, Lucas,22997 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Scott, Amanda,20652 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Navarro, Ricky, M,17221 | 7292.31 | 0.00 | 0.00 | 2443.35 | 4848.96 |
| Lewis, Austin, C,13726 | 4500.82 | 0.00 | 0.00 | 2181.56 | 2319.26 |
| Chander, Michele,18508 | 2359.96 | 0.00 | 0.00 | 0.00 | 2359.96 |
| Subram, Brandy,25693 | 1236.78 | 0.00 | 0.00 | 0.00 | 1236.78 |
| Xie, Kathryn, M,16262 | 6949.57 | 0.00 | 0.00 | 2181.56 | 4768.01 |
| Perry, Nicole, L,24224 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Subram, Andre,28752 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Torres, Roy,27951 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Subram, Stanley, W,15925 | 5905.81 | 0.00 | 0.00 | 2443.35 | 3462.46 |
| Parker, Lucas,25869 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Cox, Jennifer, A,21934 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Mehta, Joel,13498 | 100.09 | 0.00 | 0.00 | 0.00 | 100.09 |
| Butler, Gabriel,26935 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Gonzalez, Isabella, L,26475 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Martin, Bruce, D,27936 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Navarro, Ruben,21010 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Butler, Devin, M,17153 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Howard, Amanda,13453 | 4576.53 | 0.00 | 0.00 | 2181.56 | 2394.97 |
| Powell, Kayla, A,26553 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Li, Ronnie,15650 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Alonso, Philip, L,22303 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Coleman, Faith, B,25700 | 1268.84 | 0.00 | 0.00 | 0.00 | 1268.84 |
| Chen, Noah, L,26290 | 3295.26 | 0.00 | 2071.42 | 0.00 | 1223.84 |
| Clark, Robert, B,28255 | 6051.31 | 0.00 | 3578.27 | 0.00 | 2473.04 |
| Wright, Sierra,19016 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Simmons, Connor,19119 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Alexander, Xavier, A,13017 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Griffin, Mya, L,15280 | 3114.94 | 0.00 | 782.99 | 0.00 | 2331.95 |
| Brooks, Faith,26324 | 4464.48 | 0.00 | 2071.42 | 0.00 | 2393.06 |
| Gonzalez, Lucas,17480 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Li, Arturo,27844 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Foster, Eduardo,11926 | 47.94 | 0.00 | 0.00 | 0.00 | 47.94 |
| Wang, Wesley, A,20495 | 2482.23 | 0.00 | 0.00 | 0.00 | 2482.23 |
| Rodriguez, Andrew, N,11812 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Alexander, Jessica, K,11780 | 5973.24 | 0.00 | 3578.27 | 0.00 | 2394.97 |
| Garcia, Joseph, M,11954 | 5910.55 | 0.00 | 3578.27 | 0.00 | 2332.28 |
| Stewart, Danielle, P,20707 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Carter, Gabrielle, B,16596 | 4486.54 | 0.00 | 0.00 | 2181.56 | 2304.98 |
Generated 2025-11-03 22:16:11.101 UTC