[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 188 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jones, Alexandra, B,20202 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Brown, Julia,18065 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Patterson, Alexis,21348 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 232.80 | 1148.57 |
| Baker, Sara, M,11827 | 512.47 | 0.00 | 0.00 | 148.47 | 364.00 |
| Coleman, Ian,21276 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Garcia, Kayla, L,21308 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Henderson, Austin,27643 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Allen, Sean, L,12097 | 159.22 | 0.00 | 0.00 | 0.00 | 159.22 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 0.00 | 180.79 |
| Gonzalez, Logan, J,17483 | 64.50 | 0.00 | 0.00 | 32.28 | 32.22 |
| Turner, Kaylee, M,16213 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Powell, Katherine, C,14574 | 177.60 | 0.00 | 0.00 | 0.00 | 177.60 |
| Ross, Seth, M,18433 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Bradley, Evan,18506 | 101.94 | 0.00 | 0.00 | 0.00 | 101.94 |
| Lobao, Alexandre,18926 | 91.95 | 0.00 | 0.00 | 91.95 | 0.00 |
| Foster, Alyssa, I,14875 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Xu, Louis,20104 | 66.53 | 0.00 | 0.00 | 66.53 | 0.00 |
| Alexander, Julian,13217 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Bryant, Kyle,23164 | 4807.10 | 0.00 | 3578.27 | 1228.83 | 0.00 |
| Simmons, Mariah,26683 | 1270.82 | 0.00 | 699.10 | 0.00 | 571.72 |
| Peterson, Steven, L,23449 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Sanders, Xavier,16721 | 73.75 | 0.00 | 0.00 | 0.00 | 73.75 |
| Alvarez, Melody,25070 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Thomas, Victoria, A,15536 | 249.53 | 0.00 | 0.00 | 0.00 | 249.53 |
| Bryant, Connor,23842 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 34.98 | 240.52 |
| Lee, Kayla, M,20781 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Wu, Randy, J,11647 | 2365.94 | 0.00 | 0.00 | 2365.94 | 0.00 |
| Rogers, Bryce,17402 | 2304.98 | 0.00 | 0.00 | 0.00 | 2304.98 |
| Thomas, Matthew, K,13239 | 185.70 | 0.00 | 0.00 | 0.00 | 185.70 |
| Sanders, Mason, G,23459 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Collins, Hailey,11709 | 325.89 | 0.00 | 0.00 | 21.49 | 304.40 |
| Griffin, Haley, L,18925 | 82.18 | 0.00 | 0.00 | 0.00 | 82.18 |
| Chen, Jonathan, G,13096 | 200.69 | 0.00 | 0.00 | 0.00 | 200.69 |
| Ye, Alisha, J,22008 | 4141.23 | 3578.27 | 0.00 | 0.00 | 562.96 |
| Griffin, Maria,18407 | 63.25 | 0.00 | 0.00 | 0.00 | 63.25 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
| Murphy, Maria,16011 | 3657.26 | 0.00 | 0.00 | 0.00 | 3657.26 |
| Shan, Gabriel, T,27731 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Jenkins, Megan, R,12074 | 261.38 | 0.00 | 0.00 | 0.00 | 261.38 |
| Hall, Jose, J,17601 | 225.42 | 0.00 | 0.00 | 155.45 | 69.97 |
| Martin, Noah, A,17657 | 75.97 | 0.00 | 0.00 | 75.97 | 0.00 |
| Kelly, Angel, E,15418 | 232.23 | 0.00 | 0.00 | 0.00 | 232.23 |
| Ramos, Derrick,18449 | 100.94 | 0.00 | 0.00 | 30.97 | 69.97 |
| Clark, Joseph, D,15395 | 4780.02 | 0.00 | 0.00 | 0.00 | 4780.02 |
| Taylor, Tyler, A,12032 | 614.96 | 0.00 | 0.00 | 614.96 | 0.00 |
| Rogers, Amanda, A,13920 | 266.97 | 0.00 | 0.00 | 0.00 | 266.97 |
| Cooper, Amanda, P,14606 | 4716.02 | 0.00 | 0.00 | 0.00 | 4716.02 |
| Rogers, Jared, J,12166 | 162.22 | 0.00 | 0.00 | 0.00 | 162.22 |
| Davis, Justin,28074 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Carter, Jonathan,14578 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Rodriguez, Alexandra,21642 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 2325.96 | 2393.06 |
| James, Julia,24975 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Thomas, Jeremiah,18372 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Miller, Victoria,15816 | 188.02 | 0.00 | 0.00 | 81.46 | 106.56 |
| Patterson, Austin, O,27024 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Morgan, Jada, A,11520 | 702.99 | 0.00 | 0.00 | 137.45 | 565.54 |
| Zhang, Connor, R,13853 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
Generated 2025-11-04 05:37:45.107 UTC