[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 57 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hughes, Noah, J,14005 | 3319.40 | 0.00 | 0.00 | 1000.44 | 2318.96 |
| Perez, Roy,27952 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Morgan, Jade, P,22295 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Russell, Kelly, E,19981 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hall, Hannah,13924 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Scott, Eduardo,14253 | 3394.90 | 0.00 | 0.00 | 1000.44 | 2394.46 |
| Gao, Clarence, H,12631 | 10799.52 | 0.00 | 3578.27 | 0.00 | 7221.25 |
| Subram, Ruben,12187 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| White, Noah, M,17580 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Henderson, Haley, A,11778 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Bryant, Emma, E,18569 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sara, Frederick,22651 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Yang, Kyle, C,13242 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Perez, Nancy, U,19806 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Robinson, Megan, G,16490 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Ramos, Robin,11345 | 4404.09 | 0.00 | 0.00 | 4404.09 | 0.00 |
| Blanco, Daisy, L,20551 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Gill, Roberto, W,14362 | 1845.90 | 0.00 | 0.00 | 1000.44 | 845.46 |
| Perry, Dakota,20491 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Bailey, Cole, Q,27510 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Roberts, James,23757 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Wood, Nicole,16010 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cook, Charles,11219 | 39.58 | 0.00 | 0.00 | 0.00 | 39.58 |
| Carson, Kathryn, L,18537 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Phillips, Amanda, G,19013 | 636.45 | 0.00 | 0.00 | 0.00 | 636.45 |
| Luo, Yolanda,13945 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Zhang, Alisha, G,28394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Arun, Erick, C,17802 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
Generated 2025-12-23 22:10:32.560 UTC