[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 24 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Anderson, David, A,22097 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Baker, Allison,26495 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Bell, Brooke, H,23253 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| King, Jordan, C,11020 | 2316.97 | 0.00 | 0.00 | 2316.97 | 0.00 |
| Butler, Jonathan,26180 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Coleman, Joan, W,26699 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 0.00 | 272.69 |
| Flores, Luke, L,24733 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Brown, Dylan, J,12449 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Garcia, Xavier, M,20300 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Jones, Kayla, C,18541 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 0.00 | 273.18 |
| Scott, Kaitlyn, A,12159 | 218.91 | 0.00 | 0.00 | 0.00 | 218.91 |
| Smith, Megan, J,26716 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Blue, Melanie, L,17861 | 1749.96 | 0.00 | 0.00 | 0.00 | 1749.96 |
| Hayes, Dalton, C,18882 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Kelly, Julia,23798 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Rodriguez, Anthony, G,23829 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Morris, Seth,18959 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Kelly, Bailey, R,28284 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Cook, Seth,23010 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Miller, Jill,12914 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Sharma, Yolanda, K,25048 | 3046.84 | 0.00 | 2443.35 | 0.00 | 603.49 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 0.00 | 2049.10 | 1197.45 |
| Lopez, Katelyn,11820 | 232.71 | 0.00 | 0.00 | 0.00 | 232.71 |
| Flores, Morgan,19817 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
Generated 2025-12-21 07:37:18.431 UTC