[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 93 SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Phillips, Mackenzie,12444 | 228.43 | 0.00 | 0.00 | 0.00 | 228.43 |
| Martin, Morgan,24832 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| King, Morgan,19681 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Carter, Isaac,13719 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Ross, Haley, T,25361 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 0.00 | 226.43 |
| Campbell, Lucas,29329 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Russell, Jessica,26572 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Diaz, Luis, D,11203 | 801.77 | 0.00 | 0.00 | 0.00 | 801.77 |
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 0.00 | 676.93 |
| Reed, Megan, A,18118 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Collins, Xavier, C,16646 | 250.91 | 0.00 | 0.00 | 0.00 | 250.91 |
| Gonzales, Gavin,24488 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
| Stewart, Julia, L,12902 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 32.60 | 95.20 |
| Taylor, Lucas, V,11523 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Simmons, Caleb, M,12193 | 4833.03 | 0.00 | 0.00 | 0.00 | 4833.03 |
| Zhang, Heather,16654 | 3056.32 | 0.00 | 0.00 | 0.00 | 3056.32 |
| Turner, Mary,22015 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hill, Timothy,14871 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Jones, Michael, A,22107 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Campbell, Wyatt, C,27602 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Sanders, Hailey,19647 | 282.04 | 0.00 | 0.00 | 0.00 | 282.04 |
| Watson, Erin, B,22772 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Dominguez, Erika, C,21251 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Watson, Shelby, J,14911 | 867.97 | 0.00 | 0.00 | 0.00 | 867.97 |
| Turner, Jeremiah, F,19207 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Perez, Sydney, C,22117 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Murphy, Maria,16011 | 3657.26 | 0.00 | 0.00 | 0.00 | 3657.26 |
| Walker, Emma, M,25209 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Kelly, Trinity,26095 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Flores, Emily,13206 | 163.19 | 0.00 | 0.00 | 0.00 | 163.19 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| Chandra, Allen,29327 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Gonzales, Nathan, M,12107 | 222.23 | 0.00 | 0.00 | 0.00 | 222.23 |
| Richardson, Nathaniel,12089 | 4710.03 | 0.00 | 0.00 | 2316.97 | 2393.06 |
| Sanders, Zoe, L,24825 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Brooks, Jennifer, L,17411 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Malhotra, Gerald, A,28773 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Evans, Alexandra,24322 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| King, Gabrielle,26350 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perry, Benjamin,29165 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Gonzales, Jordan,23681 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gutierrez, Neil, L,21489 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Wood, Gabrielle, S,28787 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Blue, Paige,21703 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Turner, Amanda, L,20318 | 3241.90 | 0.00 | 2071.42 | 0.00 | 1170.48 |
| Diaz, Jason,17374 | 206.63 | 0.00 | 0.00 | 89.46 | 117.17 |
| Peterson, Alex, M,13423 | 132.90 | 0.00 | 0.00 | 0.00 | 132.90 |
| Davis, Nicholas,13201 | 73.16 | 0.00 | 0.00 | 0.00 | 73.16 |
| Davis, Emily,27267 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Collins, Jonathan,16849 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Thompson, Tyler,27502 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Perry, Marcus, L,20656 | 3245.90 | 0.00 | 0.00 | 2071.42 | 1174.48 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Coleman, Joan, W,26699 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Gonzalez, Jackson, S,14480 | 194.94 | 0.00 | 0.00 | 0.00 | 194.94 |
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Robinson, Zachary, L,13709 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Perry, Melissa,22128 | 4142.23 | 0.00 | 3578.27 | 0.00 | 563.96 |
| Lal, Jonathan,20096 | 71.46 | 0.00 | 0.00 | 0.00 | 71.46 |
| Brooks, Ian, W,28290 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Anderson, Lucas,29266 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Reed, Isaac, D,26074 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Turner, Wyatt,20034 | 5769.96 | 0.00 | 3399.99 | 0.00 | 2369.97 |
| Thomas, Victoria, A,15536 | 249.53 | 0.00 | 0.00 | 0.00 | 249.53 |
| Morgan, Andrea, M,16870 | 149.04 | 0.00 | 0.00 | 39.47 | 109.57 |
| Diaz, Aidan, L,23846 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Taylor, Tyler, A,12032 | 614.96 | 0.00 | 0.00 | 0.00 | 614.96 |
| Deng, Damien, A,16873 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Rivera, Amanda,11131 | 115.92 | 0.00 | 0.00 | 0.00 | 115.92 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
| Flores, Logan, K,14631 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Edwards, Alexandra,13358 | 2386.94 | 0.00 | 0.00 | 0.00 | 2386.94 |
| Washington, Aaron, L,24649 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Powell, Miranda, J,15304 | 4843.00 | 0.00 | 0.00 | 0.00 | 4843.00 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Gonzales, Paige,21702 | 91.94 | 0.00 | 0.00 | 0.00 | 91.94 |
| Hayes, Jason,26176 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cooper, Ariana,17348 | 205.42 | 0.00 | 0.00 | 0.00 | 205.42 |
| Perry, Jonathan, T,27026 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| McDonald, Aaron, J,27734 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Reed, Gabriella, A,27437 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hall, Wyatt,23827 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Moore, Logan,26348 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Hughes, Anna,19705 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Brooks, Evan,23401 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Luke, L,24733 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Lee, Ian,19646 | 197.04 | 0.00 | 0.00 | 0.00 | 197.04 |
| Hall, Elizabeth, L,13474 | 339.48 | 0.00 | 0.00 | 0.00 | 339.48 |
| Gonzalez, Madeline, B,18922 | 2326.96 | 0.00 | 0.00 | 0.00 | 2326.96 |
| Hughes, Luis,13084 | 1798.96 | 0.00 | 0.00 | 0.00 | 1798.96 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 0.00 | 4719.02 |
| Carter, Sydney,12959 | 203.92 | 0.00 | 0.00 | 0.00 | 203.92 |
| Mr., Sandstone, John, J,12903 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Chavez, Kara, P,13285 | 214.35 | 0.00 | 0.00 | 0.00 | 214.35 |
| Carter, Madeline, A,27522 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sánchez, Angela, C,17655 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Yuan, Leonard, F,16791 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Cox, Sara, P,27758 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Robinson, Abigail, R,18379 | 2362.27 | 0.00 | 0.00 | 0.00 | 2362.27 |
| Anderson, Ashley,20680 | 3219.58 | 0.00 | 0.00 | 2049.10 | 1170.48 |
| Simmons, Dakota, T,14110 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Zhang, Robert,18855 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Foster, Nicole, A,23494 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Thomas, Jeremiah,18372 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Martin, Brianna, M,23583 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Jones, Kayla, C,18541 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| White, Abigail, T,15866 | 145.82 | 0.00 | 0.00 | 0.00 | 145.82 |
| Ross, Isabelle, D,18554 | 155.45 | 0.00 | 0.00 | 0.00 | 155.45 |
| Shan, Christian, L,23084 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Powell, Jocelyn, A,21658 | 2641.89 | 0.00 | 0.00 | 2071.42 | 570.47 |
| Martin, Jeremiah, E,17345 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Moore, Jonathan,20478 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Edwards, Eric,24627 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Wilson, Madison, H,19828 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
Generated 2025-12-24 06:03:16.800 UTC