[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 374 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Adams, Julia, N,26073 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gonzalez, Madeline, B,18922 | 2326.96 | 0.00 | 0.00 | 0.00 | 2326.96 |
| Scott, Kaitlyn, A,12159 | 218.91 | 0.00 | 0.00 | 133.96 | 84.95 |
| Martin, Nicholas,23362 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Bradley, Jocelyn,23022 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Collins, Connor, J,27270 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Madan, Carmen, V,15567 | 4720.27 | 0.00 | 0.00 | 0.00 | 4720.27 |
| Henderson, Abigail,20441 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 94.98 | 59.56 |
| Lee, Kayla, M,20781 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Johnson, Cameron, R,13720 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Coleman, Jennifer, L,27298 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Suarez, Juan, R,16763 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Ramirez, Brian, M,11618 | 2369.96 | 0.00 | 0.00 | 2369.96 | 0.00 |
| Diaz, Thomas, O,16020 | 595.96 | 0.00 | 0.00 | 0.00 | 595.96 |
| Ross, Kelly,26076 | 76.96 | 0.00 | 0.00 | 0.00 | 76.96 |
| Ramirez, Makayla, L,17509 | 98.72 | 0.00 | 0.00 | 0.00 | 98.72 |
| Adams, Gabriel, S,19527 | 1219.45 | 0.00 | 0.00 | 0.00 | 1219.45 |
| Martinez, Jonathan,13303 | 66.25 | 0.00 | 0.00 | 0.00 | 66.25 |
| Smith, Andrew,14723 | 87.57 | 0.00 | 0.00 | 14.98 | 72.59 |
| Diaz, Faith, M,22363 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Davis, Marcus, T,17337 | 123.91 | 0.00 | 0.00 | 86.95 | 36.96 |
| Coleman, Vanessa,21589 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Stewart, Sara,17347 | 119.72 | 0.00 | 0.00 | 0.00 | 119.72 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Coleman, Alexandria, C,13289 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Baker, Robert, A,27300 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Evans, Alexandra,24322 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Kelly, Julia,23798 | 67.93 | 0.00 | 0.00 | 67.93 | 0.00 |
| Hughes, Stephanie,26316 | 1000.44 | 0.00 | 1000.44 | 0.00 | 0.00 |
| Brooks, Allison,14605 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Rubio, Javier, E,19726 | 64.24 | 0.00 | 0.00 | 64.24 | 0.00 |
| Bailey, Richard, N,22050 | 4160.53 | 3578.27 | 0.00 | 0.00 | 582.26 |
| Walker, Charles,11677 | 298.21 | 0.00 | 0.00 | 0.00 | 298.21 |
| Bell, Danielle,14041 | 4765.02 | 0.00 | 0.00 | 0.00 | 4765.02 |
| Garcia, Victoria, V,24501 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Rodriguez, Cesar, L,25335 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Rodriguez, Michael, E,16810 | 3064.63 | 0.00 | 0.00 | 0.00 | 3064.63 |
| Flores, Caleb, S,12165 | 280.64 | 0.00 | 0.00 | 243.37 | 37.27 |
| Phillips, Andrea,18573 | 83.74 | 0.00 | 0.00 | 0.00 | 83.74 |
| Gonzales, Ryan, M,17373 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ortega, Byron,23306 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Gray, Jesse,14626 | 197.04 | 0.00 | 0.00 | 0.00 | 197.04 |
| Kelly, Haley,15511 | 128.56 | 0.00 | 0.00 | 0.00 | 128.56 |
| Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Wilson, Tyler, L,15879 | 196.93 | 0.00 | 0.00 | 0.00 | 196.93 |
| Russell, Chloe, M,12763 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Smith, Austin,13707 | 149.05 | 0.00 | 0.00 | 0.00 | 149.05 |
| Ashe, Alexis, S,19414 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Butler, Victoria,13284 | 4767.53 | 0.00 | 0.00 | 0.00 | 4767.53 |
| Cooper, Jacqueline, S,27634 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Patterson, Abigail, H,14478 | 4795.01 | 0.00 | 0.00 | 0.00 | 4795.01 |
| Butler, Jonathan,26180 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Smith, Katherine, J,13197 | 105.19 | 0.00 | 0.00 | 0.00 | 105.19 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 0.00 | 478.95 |
| Rogers, Paige, H,17125 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Smith, Hannah, J,25265 | 54.98 | 0.00 | 0.00 | 54.98 | 0.00 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Robinson, Abigail, R,18379 | 2362.27 | 0.00 | 0.00 | 0.00 | 2362.27 |
| Price, Stephanie,25892 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Washington, Thomas, C,27451 | 37.43 | 0.00 | 0.00 | 0.00 | 37.43 |
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Smith, Lucas, P,18090 | 64.91 | 0.00 | 0.00 | 0.00 | 64.91 |
| Richardson, Victoria, C,24817 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Lee, Don,18839 | 2384.97 | 0.00 | 0.00 | 0.00 | 2384.97 |
| Adams, Kyle, E,18812 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Hughes, Luke, I,27014 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Cooper, Brooke,19536 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| White, Tyler,14291 | 258.44 | 0.00 | 0.00 | 49.97 | 208.47 |
| Murphy, Richard, M,22299 | 4145.54 | 0.00 | 3578.27 | 0.00 | 567.27 |
| Washington, Kayla, E,14655 | 174.96 | 0.00 | 0.00 | 69.97 | 104.99 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Campbell, Isabella, C,20350 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Walker, Ian,16771 | 104.55 | 0.00 | 0.00 | 54.58 | 49.97 |
| Griffin, Jennifer, B,14244 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Martinez, Andrew, C,11530 | 523.81 | 0.00 | 0.00 | 142.94 | 380.87 |
| Ross, Isabelle, D,18554 | 155.45 | 0.00 | 0.00 | 69.97 | 85.48 |
| Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 107.26 | 92.94 |
| Taylor, Brianna,17027 | 230.90 | 0.00 | 0.00 | 51.96 | 178.94 |
| Rodriguez, Nicholas, D,14604 | 137.95 | 0.00 | 0.00 | 58.97 | 78.98 |
| Ramirez, Sydney,26700 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Alexander, Luke,29043 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
| Brown, Isabella, L,26692 | 1266.86 | 0.00 | 699.10 | 0.00 | 567.76 |
| Flores, Julia, E,17263 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Griffin, Thomas, J,19015 | 125.43 | 0.00 | 0.00 | 94.46 | 30.97 |
| Gonzales, Jordan,23681 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Mitchell, Lucas, C,19829 | 4533.45 | 3374.99 | 0.00 | 0.00 | 1158.46 |
| Lopez, Jack, I,29047 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Perez, Savannah, J,17036 | 176.95 | 0.00 | 0.00 | 56.97 | 119.98 |
| Green, Xavier,23567 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Moore, Jonathan,20478 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Sanchez, Trinity, J,26279 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Roberts, Hunter,28260 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Morris, Alyssa,28072 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Phillips, Isaiah,28631 | 144.47 | 0.00 | 0.00 | 144.47 | 0.00 |
| Robinson, Lauren,27196 | 68.49 | 0.00 | 0.00 | 68.49 | 0.00 |
| James, Juan,23267 | 4862.09 | 0.00 | 3578.27 | 1283.82 | 0.00 |
| Foster, Isabel, M,21745 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Scott, Sean, F,24755 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Roberts, Thomas, J,21939 | 4163.24 | 3578.27 | 0.00 | 0.00 | 584.97 |
| Young, Julia, J,27414 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Coleman, Dylan,27403 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Moreno, Lance, A,29229 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Prasad, Donald,15413 | 318.92 | 0.00 | 0.00 | 123.98 | 194.94 |
| Xu, Louis,20104 | 66.53 | 0.00 | 0.00 | 66.53 | 0.00 |
| Lal, Kyle,17360 | 122.18 | 0.00 | 0.00 | 0.00 | 122.18 |
| Dominguez, Erika, C,21251 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Martin, John, A,14436 | 4776.01 | 0.00 | 0.00 | 0.00 | 4776.01 |
| Moore, Chloe, L,26269 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Foster, Alyssa, I,14875 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Miller, Alexis, A,12196 | 124.93 | 0.00 | 0.00 | 0.00 | 124.93 |
| Mehta, Rebekah, B,27419 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 77.77 | 769.00 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 66.26 | 773.89 |
| Evans, Dalton, E,12710 | 4774.04 | 0.00 | 0.00 | 2354.98 | 2419.06 |
| Butler, Benjamin, C,18972 | 2369.97 | 0.00 | 0.00 | 0.00 | 2369.97 |
| Perry, Marcus, L,20656 | 3245.90 | 0.00 | 0.00 | 2071.42 | 1174.48 |
| Yuan, Leonard, F,16791 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Brooks, Evan,23401 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-11-04 08:55:37.822 UTC