[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 687 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanchez, Mariah, R,19220 | 66.65 | 0.00 | 0.00 | 0.00 | 66.65 |
| Blue, Makayla,19000 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Perry, Ryan,13249 | 4795.34 | 0.00 | 0.00 | 0.00 | 4795.34 |
| Robinson, Julia,28121 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Malhotra, Kristi, S,15175 | 4850.33 | 0.00 | 0.00 | 0.00 | 4850.33 |
| Yang, Aaron, C,25196 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Nelson, Luis,23488 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sharma, Thomas, A,18637 | 121.94 | 0.00 | 0.00 | 0.00 | 121.94 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 0.00 | 226.43 |
| Wilson, Grace,17539 | 205.92 | 0.00 | 0.00 | 0.00 | 205.92 |
| Suarez, Juan, R,16763 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Rivera, Makayla, A,28783 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Chen, Jackson, S,27075 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Martin, Brandon, S,21691 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lopez, Carlos,18617 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Nelson, Jennifer,17147 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Stewart, Julia, L,12902 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Collins, Alex, S,28781 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Adams, Hailey, M,12154 | 4798.53 | 0.00 | 0.00 | 0.00 | 4798.53 |
| Bryant, Brittany,22545 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Cook, Megan, J,20299 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Hughes, Jasmine,27628 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perez, Jordan, A,29267 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Henderson, Logan, C,22366 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Reed, Judith, D,25347 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Flores, Nathan, C,24637 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Griffin, Stephanie, L,28261 | 27.92 | 0.00 | 0.00 | 0.00 | 27.92 |
| Bradley, Alexandria,17691 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
| Bailey, Hailey, R,26270 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hughes, Brittany,14387 | 898.46 | 0.00 | 0.00 | 0.00 | 898.46 |
| Yuan, Carly,19839 | 194.96 | 0.00 | 0.00 | 0.00 | 194.96 |
| Zhang, Heather,16654 | 3056.32 | 0.00 | 0.00 | 0.00 | 3056.32 |
| Powell, Lauren, E,19662 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Martinez, Kristina, S,21345 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Bailey, Mariah, L,27243 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Reed, Mariah,26373 | 1565.91 | 0.00 | 0.00 | 1000.44 | 565.47 |
| Thomas, Samantha,21690 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Foster, Isabel, M,21745 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Adams, Mackenzie, A,14640 | 812.42 | 0.00 | 0.00 | 0.00 | 812.42 |
| Gonzalez, Jeremiah,17468 | 128.91 | 0.00 | 0.00 | 0.00 | 128.91 |
| Brooks, Bryce,12061 | 140.17 | 0.00 | 0.00 | 74.98 | 65.19 |
| Evans, Gabriel,23487 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Price, Nicole, N,15815 | 141.83 | 0.00 | 0.00 | 0.00 | 141.83 |
| Hayes, Carson, A,12447 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 0.00 | 131.54 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| White, Miguel, S,13988 | 195.52 | 0.00 | 0.00 | 0.00 | 195.52 |
| Campbell, Alex,11984 | 4730.32 | 0.00 | 0.00 | 0.00 | 4730.32 |
| Clark, Lauren,17034 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Wilson, Christian,27085 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Campbell, Hailey,15507 | 267.84 | 0.00 | 0.00 | 228.96 | 38.88 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Hall, Charles,23476 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Diaz, Hunter, S,27242 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| James, Christina,17409 | 219.92 | 0.00 | 0.00 | 0.00 | 219.92 |
| Taylor, Victoria,26013 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Perry, Christian,24671 | 4354.60 | 0.00 | 3578.27 | 0.00 | 776.33 |
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
Generated 2025-12-23 05:02:18.595 UTC