[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 126 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Diaz, Elijah,20000 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Bradley, Jocelyn,23022 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Harris, Megan,23281 | 4828.11 | 0.00 | 3578.27 | 1249.84 | 0.00 |
| Bryant, Isabelle,23397 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| White, Cameron,23830 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Washington, Vanessa,23819 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Rodriguez, Morgan,23730 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Coleman, Benjamin, F,23486 | 5343.23 | 0.00 | 3578.27 | 0.00 | 1764.96 |
| Anderson, Megan, A,23859 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Diaz, Aidan, L,23846 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Foster, Olivia,23806 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Long, Kaitlyn,23396 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Campbell, Evan, W,24342 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Jones, Madison,24661 | 4181.76 | 0.00 | 3578.27 | 603.49 | 0.00 |
| Mitchell, Katelyn, A,24496 | 4349.61 | 0.00 | 3578.27 | 0.00 | 771.34 |
| Murphy, Shelby,24489 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cook, Megan, J,20299 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Watson, Olivia, S,13860 | 93.85 | 0.00 | 0.00 | 14.98 | 78.87 |
| Reed, Judith, D,25347 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Flores, Emma, P,15543 | 180.94 | 0.00 | 0.00 | 0.00 | 180.94 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 49.97 | 121.50 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Martinez, Andrew, C,11530 | 523.81 | 0.00 | 0.00 | 142.94 | 380.87 |
| Coleman, Isabel, S,12530 | 337.90 | 0.00 | 0.00 | 123.98 | 213.92 |
| Evans, Luke,29176 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Price, Nicole, N,15815 | 141.83 | 0.00 | 0.00 | 0.00 | 141.83 |
| Stewart, Destiny,13144 | 281.47 | 0.00 | 0.00 | 134.98 | 146.49 |
| Edwards, Connor,16950 | 211.01 | 0.00 | 0.00 | 0.00 | 211.01 |
| Stewart, Julia, L,12902 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Hughes, Morgan, T,11642 | 392.89 | 0.00 | 0.00 | 49.48 | 343.41 |
| Washington, Elijah, L,25016 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Mariah,16380 | 195.95 | 0.00 | 0.00 | 0.00 | 195.95 |
| Adams, Mackenzie, A,14640 | 812.42 | 0.00 | 0.00 | 0.00 | 812.42 |
| Lopez, Jack, I,29047 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Coleman, Jose, S,25349 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| White, Miguel, S,13988 | 195.52 | 0.00 | 0.00 | 0.00 | 195.52 |
| Ortega, Javier, P,12785 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Stewart, Brooke, R,24759 | 4369.59 | 0.00 | 3578.27 | 0.00 | 791.32 |
| Robinson, Sarah, A,27028 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Campbell, Hailey,15507 | 267.84 | 0.00 | 0.00 | 228.96 | 38.88 |
| Russell, Kaitlyn, M,24491 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Perry, Christian,24671 | 4354.60 | 0.00 | 3578.27 | 0.00 | 776.33 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 0.00 | 111.89 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Ward, Ian,12056 | 213.92 | 0.00 | 0.00 | 0.00 | 213.92 |
| Watson, Kimberly, A,20188 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Richardson, Victoria, C,24817 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Sandberg, Nicole, M,12077 | 144.69 | 0.00 | 0.00 | 94.46 | 50.23 |
| Hughes, Julia,25061 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Martin, Morgan,24832 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Turner, Amanda, L,20318 | 3241.90 | 0.00 | 2071.42 | 0.00 | 1170.48 |
| Butler, Morgan, E,20500 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Gray, Alexandria, E,25363 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Price, Stephanie,25892 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Murphy, Dalton, N,27043 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Morgan, Angela,24665 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Cox, Lucas, J,25393 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Campbell, Isabella, C,20350 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Ross, Alexia, S,13231 | 247.90 | 0.00 | 0.00 | 0.00 | 247.90 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Williams, Morgan, C,20373 | 3226.90 | 0.00 | 0.00 | 2071.42 | 1155.48 |
| Sanders, Alexandra,25911 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Martinez, Matthew, L,16009 | 170.45 | 0.00 | 0.00 | 0.00 | 170.45 |
| Gonzales, Melissa, W,20470 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Blanco, Randall,26321 | 1554.41 | 0.00 | 0.00 | 1000.44 | 553.97 |
| King, Caleb, J,28986 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Reed, Mariah,26373 | 1565.91 | 0.00 | 0.00 | 1000.44 | 565.47 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Ramirez, Sydney,26700 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thomas, Isabella, M,27265 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Anderson, Ashley,20680 | 3219.58 | 0.00 | 0.00 | 2049.10 | 1170.48 |
| Williams, Edward, D,14274 | 121.56 | 0.00 | 0.00 | 0.00 | 121.56 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 0.00 | 478.95 |
| Howard, Alexandra,20736 | 3194.58 | 0.00 | 0.00 | 2049.10 | 1145.48 |
| Taylor, Victoria,26013 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
| Davis, Emily,27267 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2616.86 | 0.00 |
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Collins, Connor, J,27270 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| He, Micah,27401 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Martin, Brandon, S,21691 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hughes, Isabella,23048 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 0.00 | 4693.04 |
| Hayes, Carson, A,12447 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Bell, Danielle,14041 | 4765.02 | 0.00 | 0.00 | 0.00 | 4765.02 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Washington, Alexandra, E,15498 | 256.52 | 0.00 | 0.00 | 74.46 | 182.06 |
| Diaz, Thomas, O,16020 | 595.96 | 0.00 | 0.00 | 0.00 | 595.96 |
| Taylor, Christian,20764 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
| Smith, Justin, P,19827 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Jackson, Hannah, G,13143 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Brown, Fernando,19001 | 91.95 | 0.00 | 0.00 | 69.97 | 21.98 |
| Foster, Samuel, M,18523 | 160.94 | 0.00 | 0.00 | 128.97 | 31.97 |
| Bryant, Gabriel,27656 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Harrison, Trevor, A,18055 | 143.91 | 0.00 | 0.00 | 36.96 | 106.95 |
| Foster, Edward, R,18355 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Gonzales, Kayla,21494 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cooper, Andrea,29323 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Alexander, Jason,29328 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| 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 |
| Hayes, Hannah, J,21656 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| White, Tyler,14291 | 258.44 | 0.00 | 0.00 | 49.97 | 208.47 |
| Thomas, David,16836 | 3193.79 | 0.00 | 0.00 | 0.00 | 3193.79 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Ward, Stephanie, A,27429 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Brooks, Mariah,21620 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Johnson, Andrew, F,26294 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| 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 |
| Garcia, Lucas,27545 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
Generated 2025-11-04 10:17:56.118 UTC