[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 500 < SKIP 187 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Phillips, Aaron, R,24947 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rivera, Ariana,26173 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hill, Katherine, L,26701 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Watson, Janet, S,23208 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Li, Thomas,18116 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Baker, Sara, M,11827 | 512.47 | 0.00 | 0.00 | 0.00 | 512.47 |
| Taylor, Christian,20764 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
| Murphy, Maria,16011 | 3657.26 | 0.00 | 0.00 | 0.00 | 3657.26 |
| Russell, Chloe, M,12763 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Alexander, Taylor,17482 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Hall, Wyatt,23827 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Cooper, Angela,19526 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Bell, Alex, M,16754 | 3118.60 | 0.00 | 0.00 | 0.00 | 3118.60 |
| Flores, Luke, L,24733 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Barnes, Ian, M,16106 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Ross, Elizabeth, E,14118 | 4741.34 | 0.00 | 0.00 | 0.00 | 4741.34 |
| Taylor, Taylor,15905 | 4899.02 | 0.00 | 0.00 | 0.00 | 4899.02 |
| Russell, Gail, L,21263 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hughes, Isabella,23048 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Nath, Carl, H,29001 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| White, James,25331 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lee, Ethan, J,22359 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
| Thompson, Blake,18390 | 141.96 | 0.00 | 0.00 | 0.00 | 141.96 |
| Robinson, William,20103 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Bell, Chase,18091 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Washington, Ryan,28332 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Davis, Nicholas,13201 | 73.16 | 0.00 | 0.00 | 0.00 | 73.16 |
| Gonzalez, Morgan,13065 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Washington, Alexandra, E,15498 | 256.52 | 0.00 | 0.00 | 0.00 | 256.52 |
| Turner, Timothy, C,14641 | 119.86 | 0.00 | 0.00 | 0.00 | 119.86 |
| Allen, Allison, A,19757 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Reed, Mariah,26373 | 1565.91 | 0.00 | 0.00 | 1000.44 | 565.47 |
| Cooper, Amanda, P,14606 | 4716.02 | 0.00 | 0.00 | 0.00 | 4716.02 |
| Perry, Eric,18314 | 115.73 | 0.00 | 0.00 | 0.00 | 115.73 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 0.00 | 2049.10 | 1197.45 |
| Davis, Justin,28074 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Howard, Alyssa, A,11513 | 863.95 | 0.00 | 0.00 | 0.00 | 863.95 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Rodriguez, Alexandra,21642 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Flores, Julia, E,17263 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Flores, Megan, N,23074 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Barnes, Elizabeth, J,24939 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thomas, Isabella, M,27265 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Chen, Jack, E,17579 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Richardson, Evan, J,15488 | 165.30 | 0.00 | 0.00 | 0.00 | 165.30 |
| Cooper, Christina, C,26512 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Gonzalez, Molly,16370 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Gonzales, Jose,22014 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Robinson, Jennifer, L,26504 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Gray, Isabella,16820 | 3217.79 | 0.00 | 0.00 | 0.00 | 3217.79 |
| Alexander, Luke,29043 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ye, Alisha, J,22008 | 4141.23 | 0.00 | 3578.27 | 0.00 | 562.96 |
| Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 0.00 | 161.28 |
| Cox, Julia, A,20670 | 3228.57 | 0.00 | 0.00 | 2049.10 | 1179.47 |
| Reed, Kaylee, R,17371 | 151.92 | 0.00 | 0.00 | 0.00 | 151.92 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Anderson, Ashley,20680 | 3219.58 | 0.00 | 0.00 | 2049.10 | 1170.48 |
Generated 2026-01-04 13:36:39.905 UTC