[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 33 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Malhotra, Barry,20845 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Tang, Michele,16469 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Ms., Zhang, Autumn, D,22773 | 215.96 | 0.00 | 0.00 | 0.00 | 215.96 |
| Srini, George,16136 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Ward, Charles,22356 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Gray, Kaitlyn, L,14089 | 1893.91 | 0.00 | 0.00 | 1000.44 | 893.47 |
| Thompson, Dylan, D,26108 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Zeng, Susan,16825 | 61.45 | 0.00 | 0.00 | 0.00 | 61.45 |
| James, Brianna,17010 | 2384.97 | 0.00 | 0.00 | 0.00 | 2384.97 |
| Cooper, Jessica,16015 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| King, Courtney, L,13213 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Watson, Dalton, P,26201 | 4498.46 | 0.00 | 2071.42 | 0.00 | 2427.04 |
| King, Eduardo,22110 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ma, Sandra, N,17992 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Taylor, Brandon, C,27737 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Wilson, Marcus, L,12975 | 4618.53 | 0.00 | 2181.56 | 0.00 | 2436.97 |
| Yang, Mandy,21724 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Pal, Kelsey,29409 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Barnes, Miranda,21062 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Simmons, Devin, K,12102 | 5903.19 | 0.00 | 3578.27 | 0.00 | 2324.92 |
| Torres, Robin, H,13864 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Green, Jack,12137 | 92.27 | 0.00 | 0.00 | 0.00 | 92.27 |
| Yang, Austin, H,22992 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Wood, Faith, V,21524 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Gonzales, Angelica, K,27192 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Scott, Kaylee, L,21793 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Carlson, Teresa, L,12852 | 4411.37 | 0.00 | 0.00 | 2049.10 | 2362.27 |
| Bennett, Destiny,21920 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Gonzalez, Thomas, M,18964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chen, Rafael, R,22023 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
Generated 2025-12-23 07:51:28.028 UTC