[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 500 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Carter, Sydney,12959 | 203.92 | 0.00 | 0.00 | 0.00 | 203.92 |
| Price, Rachel, D,25328 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Stewart, Destiny,13144 | 281.47 | 0.00 | 0.00 | 0.00 | 281.47 |
| Moore, Taylor, A,19987 | 4564.45 | 0.00 | 3374.99 | 0.00 | 1189.46 |
| Cook, Joan,23554 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Reed, Kaylee, R,17371 | 151.92 | 0.00 | 0.00 | 0.00 | 151.92 |
| Bradley, Rachel,15850 | 4813.04 | 0.00 | 0.00 | 0.00 | 4813.04 |
| Cox, Arianna, D,18927 | 89.25 | 0.00 | 0.00 | 0.00 | 89.25 |
| Serrano, Albert, E,13328 | 4708.02 | 0.00 | 0.00 | 0.00 | 4708.02 |
| Simmons, Caleb, M,12193 | 4833.03 | 0.00 | 0.00 | 0.00 | 4833.03 |
| Dominguez, Erika, C,21251 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Rodriguez, Lucas, P,15942 | 191.87 | 0.00 | 0.00 | 0.00 | 191.87 |
| Long, Sydney,27921 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jai, Hunter, M,28272 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Rubio, Jaime, R,15007 | 209.83 | 0.00 | 0.00 | 0.00 | 209.83 |
| Garcia, Benjamin, L,17595 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Coleman, Dylan,27403 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Alexander, Caroline,17654 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Peterson, Julia, P,16497 | 132.71 | 0.00 | 0.00 | 0.00 | 132.71 |
| Baker, Isaiah,12106 | 169.54 | 0.00 | 0.00 | 0.00 | 169.54 |
| Washington, Hailey, S,25885 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Robinson, Sarah, A,27028 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Evans, Kaylee,19642 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| James, Adrian, C,25340 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rubio, Javier, E,19726 | 64.24 | 0.00 | 0.00 | 0.00 | 64.24 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Prasad, Summer, M,22143 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Simmons, Dakota, T,14110 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Taylor, Lucas, V,11523 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Smith, Chloe,17619 | 163.92 | 0.00 | 0.00 | 0.00 | 163.92 |
Generated 2025-12-23 05:03:21.366 UTC