[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Parker, Jordan,21621 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Thomas, Thomas,21629 | 2624.08 | 0.00 | 0.00 | 2049.10 | 574.98 |
| Garcia, Lucas,27545 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Blue, Marcus, L,27550 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Campbell, Wyatt, C,27602 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Morgan, Brianna, D,11136 | 2380.47 | 0.00 | 0.00 | 2380.47 | 0.00 |
| Griffin, Julian, M,11328 | 4718.04 | 0.00 | 0.00 | 2319.99 | 2398.05 |
| Russell, Elijah, M,11835 | 4772.30 | 0.00 | 0.00 | 2319.26 | 2453.04 |
| Perry, Lauren,24816 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Reed, Sean, L,14597 | 4803.31 | 0.00 | 0.00 | 0.00 | 4803.31 |
| Parker, Madeline, H,22182 | 6006.32 | 0.00 | 3578.27 | 0.00 | 2428.05 |
| Adams, Carlos,19822 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Adams, Katherine, M,23518 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Campbell, Natalie, L,11512 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Williams, Edward, D,14274 | 121.56 | 0.00 | 0.00 | 0.00 | 121.56 |
| Sanders, Xavier,16721 | 73.75 | 0.00 | 0.00 | 0.00 | 73.75 |
| Henderson, Luke,19200 | 109.24 | 0.00 | 0.00 | 0.00 | 109.24 |
| Carter, Sydney,12959 | 203.92 | 0.00 | 0.00 | 0.00 | 203.92 |
| Campbell, Chloe,11212 | 760.93 | 0.00 | 0.00 | 231.72 | 529.21 |
| Rogers, Jade, I,14332 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Brooks, Jennifer, L,17411 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Long, Jordyn,17338 | 47.25 | 0.00 | 0.00 | 0.00 | 47.25 |
| Russell, Melanie, B,15478 | 182.83 | 0.00 | 0.00 | 167.85 | 14.98 |
| Baker, Isaiah,12106 | 169.54 | 0.00 | 0.00 | 0.00 | 169.54 |
| Edwards, Logan,25002 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Garcia, Rachel, L,12986 | 4823.01 | 0.00 | 0.00 | 2369.97 | 2453.04 |
| Miller, Destiny,25157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Moore, Taylor, A,19987 | 4564.45 | 0.00 | 3374.99 | 0.00 | 1189.46 |
| Ramos, Derrick,18449 | 100.94 | 0.00 | 0.00 | 30.97 | 69.97 |
| Thompson, Jose,23731 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Rodriguez, Anthony, G,23829 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Flores, Caleb, S,12165 | 280.64 | 0.00 | 0.00 | 243.37 | 37.27 |
| Reed, Kaylee, R,17371 | 151.92 | 0.00 | 0.00 | 0.00 | 151.92 |
| Bradley, Rachel,15850 | 4813.04 | 0.00 | 0.00 | 0.00 | 4813.04 |
| Murphy, Brianna, K,28342 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| King, Sara,22354 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Foster, Aaron,15566 | 4912.47 | 0.00 | 0.00 | 0.00 | 4912.47 |
| Serrano, Albert, E,13328 | 4708.02 | 0.00 | 0.00 | 0.00 | 4708.02 |
| Simmons, Caleb, M,12193 | 4833.03 | 0.00 | 0.00 | 2394.97 | 2438.06 |
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 37.29 | 49.96 |
| Bell, Brooke, H,23253 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| She, Martha, E,22251 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Anderson, Jasmine, A,23553 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| James, Maria,16243 | 91.97 | 0.00 | 0.00 | 69.99 | 21.98 |
| Wilson, Jeremy, T,28341 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 23.97 | 194.96 |
| Adams, Kaitlyn, A,11869 | 239.60 | 0.00 | 0.00 | 37.27 | 202.33 |
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Gonzalez, Katherine,22234 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Dominguez, Meghan,14370 | 122.56 | 0.00 | 0.00 | 0.00 | 122.56 |
| Brooks, Bryce,12061 | 140.17 | 0.00 | 0.00 | 112.25 | 27.92 |
| Howard, Natalie,13491 | 54.96 | 0.00 | 0.00 | 14.98 | 39.98 |
| Thomas, Jessica,16848 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Smith, Austin,13707 | 149.05 | 0.00 | 0.00 | 0.00 | 149.05 |
| Kennedy, Bridget,22026 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzalez, Jordan,15157 | 213.94 | 0.00 | 0.00 | 123.98 | 89.96 |
| Butler, Trevor,27415 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Taylor, Brianna,17027 | 230.90 | 0.00 | 0.00 | 145.42 | 85.48 |
| Peterson, Jessica, M,11868 | 247.01 | 0.00 | 0.00 | 61.97 | 185.04 |
| Barnes, Haley, J,21339 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 107.26 | 92.94 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 42.59 | 85.21 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Martin, Jeremiah, E,17345 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 49.97 | 121.50 |
| Moore, Andrew, A,13944 | 150.13 | 0.00 | 0.00 | 36.27 | 113.86 |
| Russell, Rachel, C,21581 | 24.27 | 0.00 | 0.00 | 24.27 | 0.00 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| Alexander, Paige, W,18604 | 59.25 | 0.00 | 0.00 | 37.27 | 21.98 |
| Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 71.58 | 124.69 |
| Scott, Adam,15863 | 243.01 | 0.00 | 0.00 | 0.00 | 243.01 |
| Jones, Alexandra, B,20202 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Moore, Logan,26348 | 89.97 | 0.00 | 0.00 | 89.97 | 0.00 |
| Wright, Katelyn, A,14502 | 122.26 | 0.00 | 0.00 | 14.98 | 107.28 |
| Wilson, Andrew, R,18236 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Chen, Jack, E,17579 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Chen, Ethan,20547 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Russell, Nicole, M,18237 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Gonzales, Ashley, C,18600 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Gonzalez, Morgan,13065 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Sandberg, Chase,21904 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 160.51 | 764.10 |
| Yang, Justin, S,15363 | 4719.04 | 0.00 | 0.00 | 0.00 | 4719.04 |
| Perry, Eric,18314 | 115.73 | 0.00 | 0.00 | 56.97 | 58.76 |
| Stewart, Lucas, J,29341 | 98.97 | 0.00 | 0.00 | 0.00 | 98.97 |
| Flores, Kevin,15878 | 225.92 | 0.00 | 0.00 | 69.97 | 155.95 |
| Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
| Stewart, Amanda, M,15310 | 94.44 | 0.00 | 0.00 | 0.00 | 94.44 |
| Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Rodriguez, Brianna, J,22267 | 4167.23 | 0.00 | 3578.27 | 0.00 | 588.96 |
| Long, Natalie,14363 | 192.34 | 0.00 | 0.00 | 0.00 | 192.34 |
| Howard, Alyssa, A,11513 | 863.95 | 0.00 | 0.00 | 0.00 | 863.95 |
| Simmons, Nicole, S,26177 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Hernandez, Sierra,27393 | 123.98 | 0.00 | 0.00 | 123.98 | 0.00 |
| Sanchez, Martin, E,21631 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ramirez, Makayla, L,17509 | 98.72 | 0.00 | 0.00 | 0.00 | 98.72 |
| Thomas, Alexandra, C,23172 | 4809.39 | 0.00 | 3578.27 | 1231.12 | 0.00 |
| Rodriguez, Alexis, L,15244 | 179.19 | 0.00 | 0.00 | 42.28 | 136.91 |
| Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 118.46 | 605.10 |
| Patterson, Alexis,21348 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 127.96 | 87.33 |
| Stewart, Allison, R,18826 | 166.43 | 0.00 | 0.00 | 69.99 | 96.44 |
| Jones, Nicole,14504 | 112.27 | 0.00 | 0.00 | 0.00 | 112.27 |
| Coleman, Luke, A,11723 | 152.55 | 0.00 | 0.00 | 69.98 | 82.57 |
| Edwards, Eric,24627 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Adams, Hailey, M,12154 | 4798.53 | 0.00 | 0.00 | 2379.47 | 2419.06 |
| Flores, Zachary, H,23376 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Evans, Elijah, S,25884 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alexander, Aidan,17387 | 148.19 | 0.00 | 0.00 | 94.24 | 53.95 |
| Wilson, Chloe, A,11640 | 409.12 | 0.00 | 0.00 | 75.48 | 333.64 |
| Brown, Anna,16247 | 95.82 | 0.00 | 0.00 | 0.00 | 95.82 |
| Coleman, Stephanie,22264 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Hall, Morgan,21726 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Sanchez, Allison,16667 | 41.72 | 0.00 | 0.00 | 0.00 | 41.72 |
| Campbell, Hunter,17422 | 174.92 | 0.00 | 0.00 | 0.00 | 174.92 |
| Brown, Dylan, J,12449 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Moreno, Renee, C,12936 | 265.22 | 0.00 | 0.00 | 0.00 | 265.22 |
| Thompson, Xavier, R,15761 | 192.41 | 0.00 | 0.00 | 0.00 | 192.41 |
| Brown, Nicholas, S,11506 | 675.64 | 0.00 | 0.00 | 121.93 | 553.71 |
| Brown, Anthony, J,19399 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| King, Morgan,19681 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Bradley, Evan,18506 | 101.94 | 0.00 | 0.00 | 0.00 | 101.94 |
Generated 2025-11-01 08:56:45.066 UTC