[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 73 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Smith, John,19855 | 5709.96 | 0.00 | 3399.99 | 0.00 | 2309.97 |
| Thompson, Kayla, D,12363 | 273.90 | 0.00 | 0.00 | 0.00 | 273.90 |
| Collins, Lucas, T,21921 | 4142.75 | 0.00 | 3578.27 | 0.00 | 564.48 |
| Ward, Jade, D,14661 | 195.02 | 0.00 | 0.00 | 0.00 | 195.02 |
| Huang, Kristen,25100 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Ramirez, Brian, M,11618 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Wilson, Victoria, R,27536 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Morris, Jessica,28967 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Reed, Catherine, M,20380 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hall, Eduardo,16847 | 189.94 | 0.00 | 0.00 | 0.00 | 189.94 |
| Jenkins, Megan, R,12074 | 261.38 | 0.00 | 0.00 | 0.00 | 261.38 |
| Lewis, Kaitlyn,15906 | 4761.03 | 0.00 | 0.00 | 0.00 | 4761.03 |
| Hayes, Gavin, A,19400 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Flores, Luke, L,24733 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Smith, Megan, J,26716 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Howard, Brianna, D,24630 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mitchell, Bailey, B,26706 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Washington, Lauren, R,22998 | 5329.25 | 0.00 | 3578.27 | 1750.98 | 0.00 |
| Umeda, Masaki,16717 | 233.81 | 0.00 | 0.00 | 0.00 | 233.81 |
| Diaz, Trevor, B,20519 | 54.96 | 0.00 | 0.00 | 0.00 | 54.96 |
| Wang, Austin, A,14632 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Torres, Abigail,25367 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Baker, Ian, V,26200 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Henderson, Gabrielle, B,18603 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Xu, Louis,20104 | 66.53 | 0.00 | 0.00 | 0.00 | 66.53 |
| Perry, Brandon,22095 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Harris, Matthew,14330 | 806.76 | 0.00 | 0.00 | 0.00 | 806.76 |
Generated 2025-12-21 16:09:27.108 UTC