[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 78 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jones, Dalton, T,18951 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Malhotra, Gerald, A,28773 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| Reed, Paige,22112 | 6047.32 | 0.00 | 3578.27 | 2469.05 | 0.00 |
| Alexander, Julia, J,15291 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
| Adams, Kaitlyn, A,11869 | 239.60 | 0.00 | 0.00 | 37.27 | 202.33 |
| Bailey, Richard, N,22050 | 4160.53 | 3578.27 | 0.00 | 0.00 | 582.26 |
| Jai, Edwin,16921 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Hall, Taylor, J,16995 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Jackson, Victoria,27019 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Watson, Marcus,22715 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Martin, Christian, V,19709 | 197.25 | 0.00 | 0.00 | 0.00 | 197.25 |
| Washington, Aaron, L,24649 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Harris, Joshua, L,20280 | 95.94 | 0.00 | 0.00 | 30.97 | 64.97 |
| Perry, Ryan,13249 | 4795.34 | 0.00 | 0.00 | 0.00 | 4795.34 |
Generated 2025-11-06 04:39:21.998 UTC