[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 283 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Winston, Ethan, R,21622 | 2612.06 | 0.00 | 0.00 | 2049.10 | 562.96 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Patterson, Grace, M,27560 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thomas, Thomas,21629 | 2624.08 | 0.00 | 0.00 | 2049.10 | 574.98 |
| Blue, Marcus, L,27550 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Washington, Lauren, R,22998 | 5329.25 | 0.00 | 3578.27 | 1750.98 | 0.00 |
| King, Jordan, C,11020 | 2316.97 | 0.00 | 0.00 | 2316.97 | 0.00 |
| Anderson, Megan, A,23859 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Foster, Deb,21501 | 2661.40 | 0.00 | 0.00 | 2661.40 | 0.00 |
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Jordan,19988 | 4555.47 | 0.00 | 3399.99 | 0.00 | 1155.48 |
| Rivera, Rachel, S,28996 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Parker, Caleb, A,26318 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Thomas, David,16836 | 3193.79 | 0.00 | 0.00 | 0.00 | 3193.79 |
| Diaz, Jasmine, A,16098 | 3101.29 | 0.00 | 0.00 | 756.33 | 2344.96 |
| Lewis, Brandon, A,29037 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ramirez, Makayla, L,17509 | 98.72 | 0.00 | 0.00 | 0.00 | 98.72 |
| Griffin, Jack, L,17686 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Bailey, Lauren,15864 | 103.55 | 0.00 | 0.00 | 0.00 | 103.55 |
| Perez, Kaitlyn, A,12081 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Wilson, Daniel, K,14281 | 4746.30 | 0.00 | 0.00 | 0.00 | 4746.30 |
| Liu, Arturo,13222 | 150.41 | 0.00 | 0.00 | 0.00 | 150.41 |
| Shan, Logan,18677 | 60.96 | 0.00 | 0.00 | 29.99 | 30.97 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 34.99 | 1270.67 |
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 130.94 | 793.67 |
| Brown, Morgan,29197 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 0.00 | 155.91 |
| Wilson, Fernando,16643 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 0.00 | 478.95 |
| Morris, Mason, J,22349 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Morgan, Marcus, W,28968 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
Generated 2025-12-22 06:46:23.684 UTC