[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 51 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jones, Joshua,18401 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Rivera, Amanda,11131 | 115.92 | 0.00 | 0.00 | 0.00 | 115.92 |
| Ross, Haley, T,25361 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Yang, Justin, S,15363 | 4719.04 | 0.00 | 0.00 | 0.00 | 4719.04 |
| Watson, Marcus,22715 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Garcia, Victoria, V,24501 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 0.00 | 87.95 |
| Thompson, Ryan, M,11330 | 1111.36 | 0.00 | 0.00 | 0.00 | 1111.36 |
| Thomas, Dylan,19873 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Powell, Jocelyn, A,21658 | 2641.89 | 0.00 | 0.00 | 2071.42 | 570.47 |
| Yuan, Yolanda, C,22154 | 36.96 | 0.00 | 0.00 | 36.96 | 0.00 |
| Edwards, Mackenzie, K,23458 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Simmons, Dakota, T,14110 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Torres, Mackenzie,28153 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Williams, Zachary, B,27099 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thompson, Tyler,27502 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Hernandez, Sierra,27393 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Turner, Mary,22015 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Edwards, Alexandra,13358 | 2386.94 | 0.00 | 0.00 | 0.00 | 2386.94 |
| Howard, Isaiah,25981 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| White, Cameron,23830 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Chen, Luis, G,21252 | 94.45 | 0.00 | 0.00 | 0.00 | 94.45 |
| Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
| Rivera, Hailey, R,20792 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sandberg, Isaac,13350 | 53.97 | 0.00 | 0.00 | 0.00 | 53.97 |
| Rogers, Sara,19874 | 4544.45 | 0.00 | 3374.99 | 0.00 | 1169.46 |
| Carter, Savannah, M,12090 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
Generated 2025-12-21 19:44:54.387 UTC