[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 314 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Brooks, Isaac, M,23385 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Coleman, Miguel, D,27400 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Lewis, Brandon, A,29037 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Simmons, Brittany,29231 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Miller, Andrew, C,27110 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Murphy, Emma,19844 | 5807.93 | 0.00 | 3374.99 | 0.00 | 2432.94 |
| 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 |
| Ruiz, Philip,18077 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Parker, Natalie, A,25104 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| Martin, Madison, C,20492 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Yuan, Brendan, S,24744 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Evans, Elijah, S,25884 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Phillips, Miguel,20498 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Reed, Erin, I,14353 | 128.84 | 0.00 | 0.00 | 74.98 | 53.86 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 84.96 | 70.95 |
| Ramirez, Emma,29072 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Chow, Candice,19232 | 60.96 | 0.00 | 0.00 | 0.00 | 60.96 |
| Morgan, Timothy,14633 | 242.50 | 0.00 | 0.00 | 71.58 | 170.92 |
| Williams, Ethan,24309 | 4793.12 | 0.00 | 3578.27 | 0.00 | 1214.85 |
| Patterson, Eduardo,11142 | 866.81 | 0.00 | 0.00 | 72.26 | 794.55 |
| Flores, Xavier,23866 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 207.93 | 802.63 |
| Baker, Sara, M,11827 | 512.47 | 0.00 | 0.00 | 148.47 | 364.00 |
| Rogers, Paige, H,17125 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Collins, Connor, J,27270 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Stewart, Garrett, O,15762 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Cooper, Brianna,25925 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Jones, Alexandra, B,20202 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Alexander, Sarah,19411 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Jones, Nicole,14504 | 112.27 | 0.00 | 0.00 | 0.00 | 112.27 |
| Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Gonzales, Brianna, L,21148 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Gill, Beth,19997 | 5814.98 | 0.00 | 3374.99 | 0.00 | 2439.99 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Harris, Emily, P,19862 | 98.48 | 0.00 | 0.00 | 0.00 | 98.48 |
| Hu, Gilbert, L,28767 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Edwards, Mackenzie, K,23458 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Collins, Isaac,26077 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Stewart, Destiny,13144 | 281.47 | 0.00 | 0.00 | 134.98 | 146.49 |
| Turner, Courtney, A,22975 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Martin, Katherine, J,20273 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Malhotra, Brenda,13391 | 2405.47 | 0.00 | 0.00 | 0.00 | 2405.47 |
| Washington, Adam, G,25437 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Lopez, Carlos,18617 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Johnson, Edward, H,23279 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Garcia, Kayla, L,21308 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Mehta, Rebekah, B,27419 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Simmons, David, E,12017 | 2339.97 | 0.00 | 0.00 | 2339.97 | 0.00 |
| Thompson, Xavier, R,15761 | 192.41 | 0.00 | 0.00 | 0.00 | 192.41 |
| Sharma, Thomas, A,18637 | 121.94 | 0.00 | 0.00 | 0.00 | 121.94 |
| Brown, Dalton, N,21813 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Morgan, Brianna, D,11136 | 2380.47 | 0.00 | 0.00 | 2380.47 | 0.00 |
| Griffin, Stephanie, L,28261 | 27.92 | 0.00 | 0.00 | 0.00 | 27.92 |
| Moore, Anthony, M,24730 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Garcia, Brandon, V,24418 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Perry, Eric,18314 | 115.73 | 0.00 | 0.00 | 56.97 | 58.76 |
| Miller, Destiny,25157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Foster, Antonio,12795 | 108.54 | 0.00 | 0.00 | 66.26 | 42.28 |
| Foster, Alyssa, I,14875 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 34.98 | 240.52 |
| Young, Jenna, W,16365 | 2490.18 | 0.00 | 0.00 | 0.00 | 2490.18 |
| Simmons, Nicole, S,26177 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Robinson, Alyssa, C,23134 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Katherine, J,22079 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Morgan, Jada, A,11520 | 702.99 | 0.00 | 0.00 | 137.45 | 565.54 |
| Hall, Charles,23476 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Thomas, A,16952 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Peterson, Mason, A,18570 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Hall, Jan, M,11740 | 334.12 | 0.00 | 0.00 | 235.15 | 98.97 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2616.86 | 0.00 |
| Ms., Coleman, Abigail, C,23868 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Torres, Dalton,23503 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Ma, Tiffany,21577 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Williams, Sydney, J,15334 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 160.51 | 764.10 |
| Peterson, Gabrielle, D,24310 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Hughes, Isabella,23048 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Lee, Samantha, B,27378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Flores, Brandon, L,25621 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Wood, Gabrielle, S,28787 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Sanders, Lucas, W,26802 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Reed, Marcus,14582 | 111.79 | 0.00 | 0.00 | 14.98 | 96.81 |
| Diaz, Alyssa,13908 | 4715.33 | 0.00 | 0.00 | 0.00 | 4715.33 |
| Garcia, Christian, J,16491 | 3106.33 | 0.00 | 0.00 | 751.34 | 2354.99 |
| Martin, Joshua, A,27607 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Reed, Sean, L,14597 | 4803.31 | 0.00 | 0.00 | 0.00 | 4803.31 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 23.97 | 194.96 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Coleman, Wyatt, M,23284 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rodriguez, Julia, A,26488 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Perry, Marcus, L,20656 | 3245.90 | 0.00 | 0.00 | 2071.42 | 1174.48 |
| Howard, Danielle,28357 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Phillips, James, G,16846 | 180.95 | 0.00 | 0.00 | 123.98 | 56.97 |
| Zhang, Nathan, L,29104 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| James, Emma,12781 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Van, Bobby,27757 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Foster, Emma,15468 | 436.35 | 0.00 | 0.00 | 159.99 | 276.36 |
| Gonzales, Nathan, M,12107 | 222.23 | 0.00 | 0.00 | 32.27 | 189.96 |
| Parker, Jeremy,28668 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Bell, Garrett, J,14265 | 161.23 | 0.00 | 0.00 | 0.00 | 161.23 |
| Diaz, Hunter, S,27242 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Barnes, Kaitlyn, Z,15162 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 2325.96 | 2393.06 |
| Richardson, Melissa, E,11132 | 2371.94 | 0.00 | 0.00 | 0.00 | 2371.94 |
| Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
| Wood, Brittany,28777 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Patterson, Nicole,19729 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Robinson, Emily,12183 | 228.42 | 0.00 | 0.00 | 54.96 | 173.46 |
| Barnes, Blake, A,17865 | 1789.97 | 0.00 | 0.00 | 0.00 | 1789.97 |
| Ross, David, M,17143 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Washington, Miranda,15201 | 4793.02 | 0.00 | 0.00 | 0.00 | 4793.02 |
| Richardson, Arianna, C,12055 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Smith, Chloe,17619 | 163.92 | 0.00 | 0.00 | 0.00 | 163.92 |
| Rodriguez, Alexis, L,15244 | 179.19 | 0.00 | 0.00 | 42.28 | 136.91 |
| Griffin, Jennifer, B,14244 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
Generated 2025-11-06 06:27:56.753 UTC