[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 63 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mitchell, Bailey, B,26706 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perry, Lauren,24816 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2049.10 | 598.97 |
| White, Cameron,23830 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Umeda, Masaki,16717 | 233.81 | 0.00 | 0.00 | 0.00 | 233.81 |
| Lal, Robert, L,14084 | 138.68 | 0.00 | 0.00 | 0.00 | 138.68 |
| Walker, Emma, M,25209 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| White, Emily, M,15917 | 4679.06 | 0.00 | 0.00 | 0.00 | 4679.06 |
| Bradley, Rachel,15850 | 4813.04 | 0.00 | 0.00 | 0.00 | 4813.04 |
| Bailey, Marcus, L,18329 | 146.53 | 0.00 | 0.00 | 23.78 | 122.75 |
| Moore, Jennifer, A,21759 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Taylor, Ryan,17025 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Simmons, Dylan,16133 | 107.85 | 0.00 | 0.00 | 38.88 | 68.97 |
| Gutierrez, Jerome,12783 | 2420.46 | 0.00 | 0.00 | 0.00 | 2420.46 |
| Miller, Benjamin, G,26643 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Nelson, Luis,23488 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hill, Fernando,24763 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 0.00 | 111.89 |
| Barnes, Ian, M,16106 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Nath, Yolanda, A,24625 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hall, Eduardo,16847 | 189.94 | 0.00 | 0.00 | 0.00 | 189.94 |
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
| Bennett, Isabelle, C,18674 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 31.27 | 808.88 |
| Hall, Jan, M,11740 | 334.12 | 0.00 | 0.00 | 0.00 | 334.12 |
| Davis, Emily,27267 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 13.98 | 1276.35 |
| Foster, Olivia,23806 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Lopez, Jack, I,29047 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Long, Elizabeth, F,12782 | 2400.95 | 0.00 | 0.00 | 0.00 | 2400.95 |
| Rivera, Sara,18785 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Miller, Destiny,25157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Peterson, Kaitlyn, S,13706 | 2337.27 | 0.00 | 0.00 | 0.00 | 2337.27 |
| Walker, Hunter,27100 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 0.00 | 4719.02 |
| Turner, Mary,22015 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| He, Micah,27401 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Brown, Anthony, J,19399 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Long, Kaitlyn,23396 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Young, Courtney,17622 | 2374.98 | 0.00 | 0.00 | 0.00 | 2374.98 |
| Stewart, Cindy,14496 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 0.00 | 215.29 |
| Henderson, Luke,19200 | 109.24 | 0.00 | 0.00 | 0.00 | 109.24 |
| Richardson, Lauren, C,14867 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Ramirez, Garrett, M,17388 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Stewart, Julia, L,12902 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Butler, Dalton, A,13345 | 4759.51 | 0.00 | 0.00 | 0.00 | 4759.51 |
| Rivera, Kaitlyn, R,15490 | 4813.52 | 0.00 | 0.00 | 0.00 | 4813.52 |
| Blue, Makayla,19000 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Lewis, Morgan,17410 | 168.74 | 0.00 | 0.00 | 0.00 | 168.74 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 0.00 | 286.82 |
| Griffin, Jordan,13095 | 328.89 | 0.00 | 0.00 | 0.00 | 328.89 |
| Robinson, William,20103 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Walker, John, M,28589 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Patterson, Austin, O,27024 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Generated 2025-12-22 01:59:36.260 UTC