[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 76 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Anderson, Rachel,28057 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Martin, Elizabeth, L,19649 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Zhu, Rafael,16228 | 569.97 | 0.00 | 0.00 | 0.00 | 569.97 |
| Torres, Carrie,25372 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Lin, Roger, W,20144 | 120.46 | 0.00 | 0.00 | 0.00 | 120.46 |
| Diaz, Isabelle,23820 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Kelly, Danielle,16499 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Prasad, Michele, C,21862 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hall, Katherine,25959 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Alexander, Anna,16647 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Edwards, Jennifer,12962 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Jenkins, Tristan, R,14786 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Campbell, Morgan, W,26010 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Davis, Madison, C,14759 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cook, Eduardo,21924 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Long, Ashley,24688 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Cox, Hailey,12448 | 5915.54 | 0.00 | 3578.27 | 0.00 | 2337.27 |
| Alonso, Theresa,25155 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Shen, April, J,28547 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Garcia, Mayra, C,17837 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Baker, Jack, W,17866 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Navarro, Frank, F,11338 | 5744.95 | 0.00 | 3374.99 | 2369.96 | 0.00 |
| Davis, Sarah, V,22351 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Scott, Bailey, A,12149 | 82.93 | 0.00 | 0.00 | 0.00 | 82.93 |
| Vance, Tina,26862 | 1249.84 | 0.00 | 0.00 | 1249.84 | 0.00 |
| Kelly, Jesse,19110 | 604.96 | 0.00 | 0.00 | 0.00 | 604.96 |
| Cooper, Morgan, R,23510 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Patterson, Jacqueline, R,26480 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Robinson, Ashley, H,23003 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Ross, Aidan, D,11541 | 5973.24 | 0.00 | 3578.27 | 0.00 | 2394.97 |
Generated 2025-12-22 06:42:51.182 UTC