[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 16 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lin, Colin,11255 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Hall, Eric, C,27155 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Russell, Jasmine, A,14888 | 1898.07 | 0.00 | 699.10 | 0.00 | 1198.97 |
| Pal, Kelli, M,23067 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Washington, Oscar,22980 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Hayes, Madison,14813 | 3341.81 | 0.00 | 0.00 | 2443.35 | 898.46 |
| Foster, Julia, A,26238 | 3298.94 | 0.00 | 2049.10 | 0.00 | 1249.84 |
| Kumar, Gabriel, R,18137 | 3043.06 | 0.00 | 699.10 | 0.00 | 2343.96 |
| Hall, Sophia,27726 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Sai, Chelsea,14845 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Luo, Dawn, A,13804 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Perez, Evan, R,29222 | 4374.61 | 0.00 | 3578.27 | 0.00 | 796.34 |
| Jones, Tyler,27446 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Butler, David, H,16138 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Alexander, Zachary, A,23144 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Jai, Lindsay, R,17718 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Rana, Ebony, J,17190 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Sharma, Terry,14000 | 84.92 | 0.00 | 0.00 | 0.00 | 84.92 |
| Johnson, Devin,15985 | 3179.95 | 0.00 | 0.00 | 782.99 | 2396.96 |
| Clark, Jennifer,25881 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Russell, Abigail, H,21826 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Gray, Sydney, K,11735 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Sanders, Steven, H,29152 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Suarez, Jessie, D,13702 | 4478.84 | 0.00 | 0.00 | 2181.56 | 2297.28 |
| Taylor, Lauren, T,14594 | 163.99 | 0.00 | 0.00 | 0.00 | 163.99 |
| Diaz, Connor,21623 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Gonzalez, Darren,24204 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Williams, John, C,13238 | 4511.54 | 0.00 | 2181.56 | 0.00 | 2329.98 |
| Howard, Natalie,13491 | 121.45 | 0.00 | 0.00 | 0.00 | 121.45 |
| Sanchez, Brooke,21162 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
Generated 2025-12-22 09:31:56.497 UTC