[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 625 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lee, Ethan, J,22359 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Johnson, Edward, H,23279 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Wood, Alexandria, M,24824 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Stewart, Alex, M,20084 | 63.15 | 0.00 | 0.00 | 0.00 | 63.15 |
| Jenkins, Megan, R,12074 | 261.38 | 0.00 | 0.00 | 0.00 | 261.38 |
| Rodriguez, Nicholas, D,14604 | 137.95 | 0.00 | 0.00 | 58.97 | 78.98 |
| Bryant, Kyle,23164 | 4807.10 | 0.00 | 3578.27 | 1228.83 | 0.00 |
| Stewart, Gabriella,28034 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Xu, Louis,20104 | 66.53 | 0.00 | 0.00 | 66.53 | 0.00 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 49.97 | 121.50 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Jai, Connor, D,27253 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Simmons, Nicole, S,26177 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Ms., Coleman, Abigail, C,23868 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Jones, Madison,24661 | 4181.76 | 0.00 | 3578.27 | 603.49 | 0.00 |
| Green, Samuel, D,14096 | 174.73 | 0.00 | 0.00 | 0.00 | 174.73 |
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 116.91 | 97.35 |
| Davis, Jasmine, M,26529 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Evans, Jordan,29209 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Washington, Victoria,23557 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Foster, Trevor, J,28964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sandberg, Chase,21904 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Bell, Christina,26099 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Simmons, Dylan,16133 | 107.85 | 0.00 | 0.00 | 38.88 | 68.97 |
| Cooper, Amanda, P,14606 | 4716.02 | 0.00 | 0.00 | 0.00 | 4716.02 |
| Torres, Taylor,16666 | 205.44 | 0.00 | 0.00 | 123.98 | 81.46 |
| James, Julia,24975 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Long, Elizabeth, F,12782 | 2400.95 | 0.00 | 0.00 | 0.00 | 2400.95 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanchez, Richard, L,27406 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Lee, James, J,28817 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Bailey, Maria, C,19150 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Clark, Joseph, D,15395 | 4780.02 | 0.00 | 0.00 | 0.00 | 4780.02 |
| Turner, Andrea, A,20209 | 3268.55 | 0.00 | 2049.10 | 0.00 | 1219.45 |
| Martin, Alfredo, P,21480 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Morgan, Andrea, M,16870 | 149.04 | 0.00 | 0.00 | 116.44 | 32.60 |
| Smith, Hannah, J,25265 | 54.98 | 0.00 | 0.00 | 54.98 | 0.00 |
| Williams, Sydney, J,15334 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Green, Gabriella, C,28035 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lopez, Bailey, R,18557 | 1179.47 | 0.00 | 0.00 | 1179.47 | 0.00 |
| Bell, Alexandria, A,13758 | 284.13 | 0.00 | 0.00 | 42.28 | 241.85 |
| Rodriguez, Taylor,16071 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Parker, James,11808 | 610.19 | 0.00 | 0.00 | 186.77 | 423.42 |
| Wood, Brittany,28777 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Smith, Eduardo,20691 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Coleman, Luke, A,11723 | 152.55 | 0.00 | 0.00 | 69.98 | 82.57 |
| Moore, Andrew, A,13944 | 150.13 | 0.00 | 0.00 | 36.27 | 113.86 |
| Flores, Stephanie,25992 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Howard, Morgan, T,22971 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Liu, Arturo,13222 | 150.41 | 0.00 | 0.00 | 13.98 | 136.43 |
| Foster, Paige,27428 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Hall, Natalie, A,23070 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Edwards, Hunter,24220 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Winston, Ethan, R,21622 | 2612.06 | 0.00 | 0.00 | 2049.10 | 562.96 |
| Ross, Seth, M,18433 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Torres, Mariah,16380 | 195.95 | 0.00 | 0.00 | 0.00 | 195.95 |
| Carter, Madeline, A,27522 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Perry, James,19205 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Fernandez, Darren,28992 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Generated 2025-11-03 09:04:08.773 UTC