[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1306 > < TAKE 496 >
201 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 0.00 | 111.89 |
| Mehta, Carmen, C,27436 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Mitchell, Thomas, J,13711 | 2380.47 | 0.00 | 0.00 | 0.00 | 2380.47 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Reed, Catherine, M,20380 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Wilson, Chloe, A,11640 | 409.12 | 0.00 | 0.00 | 0.00 | 409.12 |
| Gonzales, Arianna, S,19710 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Wilson, Eduardo,15323 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Martinez, Carol, D,17656 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Smith, Chloe,17619 | 163.92 | 0.00 | 0.00 | 0.00 | 163.92 |
| Kelly, Trinity,26095 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Cooper, Grace, C,16012 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| Williams, Edward, D,14274 | 121.56 | 0.00 | 0.00 | 0.00 | 121.56 |
| Green, Gabriella, C,28035 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Smith, Alexandra,28292 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Martin, Brandon, S,21691 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Roberts, Amber, W,21582 | 2638.06 | 0.00 | 0.00 | 2049.10 | 588.96 |
| Brooks, Mariah,21620 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Garcia, Kaitlyn, J,26310 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Thomas, Richard,27557 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Parker, Jordan,21621 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Sanchez, Trinity, J,26279 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| 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 |
| Powell, Jocelyn, A,21658 | 2641.89 | 0.00 | 0.00 | 2071.42 | 570.47 |
| King, Jordan, C,11020 | 2316.97 | 0.00 | 0.00 | 2316.97 | 0.00 |
| Morgan, Brianna, D,11136 | 2380.47 | 0.00 | 0.00 | 2380.47 | 0.00 |
| Perry, Natalie,17126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Garcia, Anna, B,15572 | 104.55 | 0.00 | 0.00 | 0.00 | 104.55 |
| Price, Marissa,15826 | 160.74 | 0.00 | 0.00 | 0.00 | 160.74 |
| Gonzales, Miranda,11660 | 324.72 | 0.00 | 0.00 | 0.00 | 324.72 |
| Rivera, Rachel, S,28996 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Griffin, Marcus,20756 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Li, Kevin, S,25188 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Brown, Anthony, J,19399 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Hughes, Brittany,14387 | 898.46 | 0.00 | 0.00 | 0.00 | 898.46 |
| Campbell, Gabriella,18841 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Martinez, Jonathan,13303 | 66.25 | 0.00 | 0.00 | 0.00 | 66.25 |
| Alexander, Luke,29043 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
| Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 0.00 | 161.28 |
| Adams, Julia, N,26073 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Edwards, Hailey,24258 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Jordan,15157 | 213.94 | 0.00 | 0.00 | 0.00 | 213.94 |
| Smith, Megan, J,26716 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Flores, Caleb, S,12165 | 280.64 | 0.00 | 0.00 | 0.00 | 280.64 |
| Wedge, Andrew, T,12060 | 4811.54 | 0.00 | 0.00 | 0.00 | 4811.54 |
| Sanchez, Caitlin, M,22080 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Robinson, Ian, D,13852 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Rivera, Sara,18785 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Phillips, Haley, B,28079 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Roberts, Jordan, M,16800 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Rodriguez, Nicholas, D,14604 | 137.95 | 0.00 | 0.00 | 0.00 | 137.95 |
| Diaz, Alyssa,13908 | 4715.33 | 0.00 | 0.00 | 0.00 | 4715.33 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Flores, Julia, E,17263 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Barnes, Elizabeth, J,24939 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Thomas, O,16020 | 595.96 | 0.00 | 0.00 | 0.00 | 595.96 |
| Baker, Sara, M,11827 | 512.47 | 0.00 | 0.00 | 0.00 | 512.47 |
| Foster, Carson, L,16959 | 135.35 | 0.00 | 0.00 | 0.00 | 135.35 |
| Harris, Samantha, A,24487 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Richardson, Evan, J,15488 | 165.30 | 0.00 | 0.00 | 0.00 | 165.30 |
| Johnson, Christopher,11979 | 4813.76 | 0.00 | 0.00 | 0.00 | 4813.76 |
| Alexander, Nathan, A,18795 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Barnes, Jeremy,21446 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Griffin, Thomas, J,19015 | 125.43 | 0.00 | 0.00 | 0.00 | 125.43 |
| Moore, Ian, L,24639 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Barnes, Ian, M,16106 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gonzalez, James, M,18842 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Flores, Eduardo, S,28969 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Reed, Isaac, D,26074 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| James, Maria,16243 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Wilson, Jeremy, T,28341 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Griffin, Seth, R,17585 | 164.46 | 0.00 | 0.00 | 0.00 | 164.46 |
| Li, Rafael, M,21752 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perry, Jackson, J,21306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Kellie, R,28195 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Alexander, Jordan,21412 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Alexander, Paige, W,18604 | 59.25 | 0.00 | 0.00 | 0.00 | 59.25 |
| Edwards, Angel, J,29124 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 0.00 | 298.49 |
| Evans, Connor, J,15402 | 131.55 | 0.00 | 0.00 | 0.00 | 131.55 |
| Allen, Allison, A,19757 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Lal, Jack, R,18525 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Garcia, Kayla, L,21308 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Moore, Anthony, M,24730 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bennett, Jennifer, G,13708 | 123.94 | 0.00 | 0.00 | 0.00 | 123.94 |
| Zhang, Robert,18855 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 0.00 | 196.27 |
| Miller, Kayla, A,23673 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 0.00 | 273.18 |
| Lal, Kyle,17360 | 122.18 | 0.00 | 0.00 | 0.00 | 122.18 |
| Watson, Devin, A,18875 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| Ramirez, Garrett, M,17388 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Zhao, Clarence, R,19826 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Xu, Louis,20104 | 66.53 | 0.00 | 0.00 | 0.00 | 66.53 |
| Peterson, Steven, L,23449 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sara, Ivan, L,25090 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Gonzalez, Chelsea, E,18103 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Bradley, Rachel,15850 | 4813.04 | 0.00 | 0.00 | 0.00 | 4813.04 |
| Nath, Kenneth, W,17037 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Simmons, Nicole, S,26177 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Taylor, Lucas, V,11523 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Green, Eric,27380 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Price, Devin, M,18758 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Phillips, Andrea,18573 | 83.74 | 0.00 | 0.00 | 0.00 | 83.74 |
| Carter, Isaac,13719 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Prasad, Erick, E,28786 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| King, Gabrielle,26350 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Williams, Austin,20354 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Brooks, Steven, C,14877 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
| Gutierrez, Neil, L,21489 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Brown, Christian,22755 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Thomas, Jeremiah,18372 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Perry, James,19205 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Thompson, Brianna, X,18642 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Howard, Brianna, D,24630 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Thomas, A,16952 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Sanchez, Stephanie,17867 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Jackson, Victoria,27019 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Harris, Joshua, L,20280 | 95.94 | 0.00 | 0.00 | 0.00 | 95.94 |
| Lewis, Jeremiah,14371 | 87.26 | 0.00 | 0.00 | 0.00 | 87.26 |
| Blanco, Armando, F,13918 | 2397.95 | 0.00 | 0.00 | 0.00 | 2397.95 |
| Johnson, Madison, L,15530 | 846.46 | 0.00 | 0.00 | 0.00 | 846.46 |
| Gray, Cody, C,14459 | 4775.01 | 0.00 | 0.00 | 0.00 | 4775.01 |
| Rogers, Andrea, L,14328 | 308.66 | 0.00 | 0.00 | 0.00 | 308.66 |
| Phillips, Aaron, R,24947 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Russell, Chloe, M,12763 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Butler, Jackson, J,18324 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Cooper, Angela,19526 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Alvarez, Melody,25070 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Parker, Kaylee, M,27738 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sanders, Mason, G,23459 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Edwards, Alexandra,13358 | 2386.94 | 0.00 | 0.00 | 0.00 | 2386.94 |
| Gonzales, Gavin,24488 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ramirez, Emma,29072 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Campbell, Timothy,25845 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Russell, Gail, L,21263 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| White, James,25331 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Washington, Ryan,28332 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Gonzalez, Morgan,13065 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Perry, Eric,18314 | 115.73 | 0.00 | 0.00 | 0.00 | 115.73 |
| Howard, Alyssa, A,11513 | 863.95 | 0.00 | 0.00 | 0.00 | 863.95 |
| Kumar, Elijah,15197 | 156.92 | 0.00 | 0.00 | 0.00 | 156.92 |
| Collins, Charles, B,29041 | 628.45 | 0.00 | 0.00 | 0.00 | 628.45 |
| Lewis, Kaitlyn,15906 | 4761.03 | 0.00 | 0.00 | 0.00 | 4761.03 |
| Gonzales, Jose,22014 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Johnson, Xavier, R,23255 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raman, Emmanuel, W,19554 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Bryant, Dakota, L,17613 | 2401.95 | 0.00 | 0.00 | 0.00 | 2401.95 |
| Wood, Gabrielle, S,28787 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Martin, Tyler, L,27724 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hill, Kaitlyn, M,24659 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Wang, Benjamin, R,27454 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gray, Cindy, A,13198 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| Flores, Morgan,19817 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Evans, Jordan,29209 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Baker, Mason, A,13270 | 2394.95 | 0.00 | 0.00 | 0.00 | 2394.95 |
| Rivera, Hailey, R,20792 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Brandon, L,25621 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Hayes, Gavin, A,19400 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Andersen, Latoya, J,29057 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Perry, Benjamin,29165 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Bryant, Rachel,22019 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Peterson, Isabella,28080 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bradley, Evan,18506 | 101.94 | 0.00 | 0.00 | 0.00 | 101.94 |
| Diaz, Gabrielle,14893 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Campbell, Natalie, L,11512 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Perez, Barry, M,27282 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Rogers, Olivia,12020 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Lewis, Rachel, J,14900 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Simmons, Adam,25327 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Malhotra, Gerald, A,28773 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| Lee, Samantha, B,27378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Johnson, Ian, E,21732 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Diaz, Faith, M,22363 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Luo, Donna, E,24805 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Morgan, Isabella, L,28602 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Sanchez, Jeremiah, E,22265 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Sanders, Lucas, W,26802 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Price, Rachel, D,25328 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Kelly, Julia,23798 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Kumar, Cameron, S,18571 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Simmons, David, E,12017 | 2339.97 | 0.00 | 0.00 | 0.00 | 2339.97 |
| Peterson, Melissa, S,24995 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Anderson, Madison, G,28359 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Coleman, Alexandria, C,13289 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Parker, Jeremy,28668 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Harris, Seth, M,16140 | 2528.33 | 0.00 | 0.00 | 0.00 | 2528.33 |
| Powell, Sydney, M,14886 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Richardson, Lauren, C,14867 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| _SUM | 1806517.50 | 14313.08 | 487820.91 | 251094.68 | 1053288.83 |
Generated 2026-01-04 05:22:25.151 UTC