[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 345 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Smith, Hannah, J,25265 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Stewart, Gabriella,28034 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hall, Wyatt,23827 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Sharma, Jackson,16876 | 151.84 | 0.00 | 0.00 | 0.00 | 151.84 |
| Williams, Ethan,24309 | 4793.12 | 0.00 | 3578.27 | 0.00 | 1214.85 |
| Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
| Walker, Brandon, J,15916 | 4793.27 | 0.00 | 0.00 | 0.00 | 4793.27 |
| Bell, Chase,18091 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Lopez, Katelyn,11820 | 232.71 | 0.00 | 0.00 | 0.00 | 232.71 |
| James, Juan,23267 | 4862.09 | 0.00 | 3578.27 | 0.00 | 1283.82 |
| Kumar, Cameron, S,18571 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Hill, Jordan, J,16005 | 198.73 | 0.00 | 0.00 | 0.00 | 198.73 |
| Simmons, David, E,12017 | 2339.97 | 0.00 | 0.00 | 0.00 | 2339.97 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Coleman, Ian,21276 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lewis, Rachel, J,14900 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Powell, Jocelyn, A,21658 | 2641.89 | 0.00 | 0.00 | 2071.42 | 570.47 |
| Parker, Eduardo, M,12939 | 169.42 | 0.00 | 0.00 | 0.00 | 169.42 |
| Parker, Jeremy,28668 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Jenkins, Dakota, D,20679 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Powell, Sydney, M,14886 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Parker, James,11808 | 610.19 | 0.00 | 0.00 | 0.00 | 610.19 |
| Parker, Blake,15008 | 170.53 | 0.00 | 0.00 | 0.00 | 170.53 |
| Wright, Kaitlyn, G,13434 | 2354.99 | 0.00 | 0.00 | 0.00 | 2354.99 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Flores, Isabelle, A,15526 | 188.32 | 0.00 | 0.00 | 0.00 | 188.32 |
| Johnson, Ian, E,21732 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Griffin, Maria,18407 | 63.25 | 0.00 | 0.00 | 0.00 | 63.25 |
| Murphy, Maria,16011 | 3657.26 | 0.00 | 0.00 | 0.00 | 3657.26 |
Generated 2025-12-22 04:42:35.484 UTC