[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Luo, Peter, E,15704 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Sullivan, Phillip, J,28471 | 3374.99 | 0.00 | 3374.99 | 0.00 | 0.00 |
| Gonzalez, Douglas, E,20174 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Stewart, Isabella, M,20742 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Suarez, Eddie, A,24109 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Munoz, Lee, D,17417 | 2354.99 | 0.00 | 0.00 | 0.00 | 2354.99 |
| Perry, Devin,23709 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Munoz, Jésus, K,13697 | 2907.40 | 0.00 | 0.00 | 0.00 | 2907.40 |
| Rodriguez, Olivia, A,15285 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Jordyn,17338 | 44.91 | 0.00 | 0.00 | 0.00 | 44.91 |
| Foster, Richard, C,14379 | 1854.91 | 0.00 | 0.00 | 1000.44 | 854.47 |
| Carson, Arturo,29172 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Jenkins, Faith,21630 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Chen, Austin, V,24190 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Stewart, Janet, R,16905 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wood, Alexis, A,13985 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Powell, Kevin,27011 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Reed, Lauren, J,27016 | 41.93 | 0.00 | 0.00 | 0.00 | 41.93 |
| Ma, Candice,27260 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Ross, Dakota,11537 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Liu, Rosa,23612 | 2395.96 | 0.00 | 0.00 | 0.00 | 2395.96 |
| Munoz, Larry,11242 | 11068.01 | 0.00 | 0.00 | 4369.09 | 6698.92 |
| Madan, Jillian, A,13410 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Bell, Andrea,18775 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Thomas, Wyatt, R,12431 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sanders, Danielle, J,15358 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Lucas, B,17524 | 2316.97 | 0.00 | 0.00 | 0.00 | 2316.97 |
| Allen, Gabriella,23150 | 49.22 | 0.00 | 0.00 | 0.00 | 49.22 |
| Henderson, Arianna,12112 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Sharma, Jordan, R,17393 | 2404.91 | 0.00 | 0.00 | 0.00 | 2404.91 |
Generated 2025-12-24 05:42:09.688 UTC