[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 81 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Jordan,15157 | 213.94 | 0.00 | 0.00 | 123.98 | 89.96 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Thompson, Lucas, O,21277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rogers, Amanda, A,13920 | 266.97 | 0.00 | 0.00 | 0.00 | 266.97 |
| Lee, William,13185 | 149.84 | 0.00 | 0.00 | 0.00 | 149.84 |
| Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 0.00 | 131.54 |
| Williams, Austin,20354 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Gonzalez, Amber, L,23879 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Coleman, Alexandria, C,13289 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Malhotra, Kristi, S,15175 | 4850.33 | 0.00 | 0.00 | 0.00 | 4850.33 |
| Adams, Kyle, E,18812 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hall, Luke, E,14745 | 902.46 | 0.00 | 0.00 | 0.00 | 902.46 |
| Kelly, Bryan,21349 | 2989.38 | 0.00 | 0.00 | 2989.38 | 0.00 |
| Brown, Nicholas, S,11506 | 675.64 | 0.00 | 0.00 | 0.00 | 675.64 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Torres, Haley, W,23283 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 31.27 | 808.88 |
| Phillips, Isaiah,28631 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Gill, Robyn, J,12765 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Kumar, Cameron, S,18571 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Evans, Jordan,29209 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanchez, Nicole, L,14874 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Patterson, Alexis,21348 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Moreno, Marie,27739 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Garcia, Rachel, L,12986 | 4823.01 | 0.00 | 0.00 | 0.00 | 4823.01 |
| Smith, Lucas, P,18090 | 64.91 | 0.00 | 0.00 | 0.00 | 64.91 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 64.98 | 1090.92 |
| Bradley, Rachel,15850 | 4813.04 | 0.00 | 0.00 | 0.00 | 4813.04 |
Generated 2025-12-23 16:43:39.284 UTC