[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 688 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
| Green, Samuel, D,14096 | 174.73 | 0.00 | 0.00 | 0.00 | 174.73 |
| Fernandez, Darren,28992 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Martin, Morgan,24832 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Edwards, Mackenzie, K,23458 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Moreno, Renee, C,12936 | 265.22 | 0.00 | 0.00 | 0.00 | 265.22 |
| Martinez, Jill,24235 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Ross, Haley, T,25361 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Green, Chloe, J,14658 | 92.82 | 0.00 | 0.00 | 0.00 | 92.82 |
| Powell, Miranda, J,15304 | 4843.00 | 0.00 | 0.00 | 0.00 | 4843.00 |
| Perry, Dalton, A,16149 | 192.04 | 0.00 | 0.00 | 0.00 | 192.04 |
| Turner, Amanda, L,20318 | 3241.90 | 0.00 | 2071.42 | 0.00 | 1170.48 |
| Gonzales, Kayla,21494 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 0.00 | 2049.10 | 1197.45 |
| Rivera, Caitlin, L,26113 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Lazecky, Petr,25864 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Cook, Megan, J,20299 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Griffin, Cassidy,26496 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Morris, Richard,20070 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chen, Jackson, S,27075 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Flores, Emma, P,15543 | 180.94 | 0.00 | 0.00 | 0.00 | 180.94 |
| Williams, Zachary, B,27099 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Powell, Jack, J,18411 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Coleman, Lucas, A,27060 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 32.60 | 95.20 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Madan, Carmen, V,15567 | 4720.27 | 0.00 | 0.00 | 0.00 | 4720.27 |
| Harris, Edward,27062 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 49.97 | 121.50 |
| Evans, James, C,20665 | 4408.56 | 0.00 | 0.00 | 2049.10 | 2359.46 |
| Coleman, Wyatt, M,23284 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Williams, Morgan, C,20373 | 3226.90 | 0.00 | 0.00 | 2071.42 | 1155.48 |
| Wright, Jackson,11698 | 225.95 | 0.00 | 0.00 | 0.00 | 225.95 |
| Cox, Julia, A,20670 | 3228.57 | 0.00 | 0.00 | 2049.10 | 1179.47 |
| Stewart, Julia, L,12902 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Brooks, Bryce,12061 | 140.17 | 0.00 | 0.00 | 112.25 | 27.92 |
| Diaz, Hunter, S,27242 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Washington, Elijah, L,25016 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hughes, Miranda,26678 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Thomas, Jessica,16848 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Walker, Emma, M,25209 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Smith, Justin, P,19827 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Taylor, Victoria,26013 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Evans, Dalton, E,12710 | 4774.04 | 0.00 | 0.00 | 0.00 | 4774.04 |
| Hayes, Luis,12880 | 200.73 | 0.00 | 0.00 | 0.00 | 200.73 |
| Alexander, Jason,29328 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| Collins, Nathan, F,19704 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Wilson, Andrew, R,18236 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Parker, Caleb, A,26318 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 0.00 | 87.25 |
| Nelson, Adam, B,27402 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Shan, Logan,18677 | 60.96 | 0.00 | 0.00 | 29.99 | 30.97 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Young, Kaitlyn, J,25062 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Reed, Mariah,26373 | 1565.91 | 0.00 | 0.00 | 1000.44 | 565.47 |
| Isla, Julian, A,13732 | 108.96 | 0.00 | 0.00 | 4.99 | 103.97 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
Generated 2025-12-22 00:53:29.690 UTC