[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1375 > < TAKE 500 >
132 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Clark, Destiny, L,28600 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Cox, Katelyn, B,21742 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Rivera, Ariana,26173 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Coleman, Joan, W,26699 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Cox, Arianna, D,18927 | 89.25 | 0.00 | 0.00 | 0.00 | 89.25 |
| Ross, Elizabeth, E,14118 | 4741.34 | 0.00 | 0.00 | 0.00 | 4741.34 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Sanchez, Faith,27049 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Lewis, Ryan, A,20312 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Torres, Victoria,17551 | 160.92 | 0.00 | 0.00 | 0.00 | 160.92 |
| Perry, Justin, E,16758 | 3062.34 | 0.00 | 0.00 | 0.00 | 3062.34 |
| Harris, Samantha, A,24487 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Williams, Zachary, B,27099 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Cooper, Christina, C,26512 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Robinson, Jennifer, L,26504 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| White, Christopher, R,26049 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Coleman, Jennifer, L,27298 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ward, Juan, H,21595 | 2649.56 | 0.00 | 0.00 | 2049.10 | 600.46 |
| Perez, Kaitlyn, A,12081 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Wilson, Daniel, K,14281 | 4746.30 | 0.00 | 0.00 | 0.00 | 4746.30 |
| 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 |
| Anderson, Jasmine, A,23553 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wilson, Jeremy, T,28341 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Hall, Kaylee, E,19751 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Brown, Morgan,29197 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Patterson, Taylor,12147 | 271.45 | 0.00 | 0.00 | 0.00 | 271.45 |
| Washington, Victoria,23557 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Moreno, Marie,27739 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Barnes, Emily, G,15996 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Watson, Marcus,22715 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Kennedy, Bridget,22026 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bailey, Alexandria, V,13209 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Mehta, Carmen, C,27436 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Anand, Brendan, L,19847 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Young, Jenna, W,16365 | 2490.18 | 0.00 | 0.00 | 0.00 | 2490.18 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Blue, Paige,21703 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Martin, Jeremiah, E,17345 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Foster, Kayla,19693 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Murphy, Eduardo, S,16124 | 614.45 | 0.00 | 0.00 | 0.00 | 614.45 |
| Walker, Thomas,13071 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Peterson, Xavier, R,26456 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martinez, Carol, D,17656 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Sandberg, Chase,21904 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Roberts, Rebecca,28000 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Davis, Thomas,16764 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Coleman, Spencer,15993 | 597.26 | 0.00 | 0.00 | 0.00 | 597.26 |
| Green, Mackenzie, C,28073 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Alexander, Sarah,19411 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Wood, Brittany,28777 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Flores, Miguel,19750 | 77.25 | 0.00 | 0.00 | 0.00 | 77.25 |
| Sanchez, Nicole, L,14874 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Flores, Hannah,19525 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Lewis, Ethan,27998 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Campbell, Timothy,25845 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perry, Benjamin,29165 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Peterson, Isabella,28080 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mohamed, Samantha, A,29277 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Foster, Jessica,26069 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Williams, Joshua,26051 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chen, David,27208 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Russell, Katherine,28771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Martin, Alfredo, P,21480 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Roberts, Wyatt,15900 | 699.97 | 0.00 | 0.00 | 0.00 | 699.97 |
| Sanchez, Jeremiah, E,22265 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Baker, Robert, A,27300 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Harris, Noah,29256 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Sanchez, Katherine, S,24399 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Jackson, Victoria,27019 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Stewart, Amanda, M,15310 | 94.44 | 0.00 | 0.00 | 0.00 | 94.44 |
| Thompson, Brianna, X,18642 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Reed, Kaitlyn, H,27413 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Scott, Allison,14497 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Alexander, Logan, E,19116 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Russell, Chloe, M,12763 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Alexander, Julian,13217 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Edwards, Hunter,24220 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Bryant, Dakota, L,17613 | 2401.95 | 0.00 | 0.00 | 0.00 | 2401.95 |
| Baker, Mason, A,13270 | 2394.95 | 0.00 | 0.00 | 0.00 | 2394.95 |
| Malhotra, Brenda,13391 | 2405.47 | 0.00 | 0.00 | 0.00 | 2405.47 |
| Ross, Miranda,14598 | 4839.00 | 0.00 | 0.00 | 0.00 | 4839.00 |
| Thames, Bernard,23803 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Thomas, Ian,19118 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Patterson, Cassidy, A,17586 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Roberts, Carlos,23196 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Ryan,28332 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Sanders, Angel,16219 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Coleman, Stephanie,22264 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Brown, Dylan, J,12449 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Ward, Mariah, J,21580 | 44.91 | 0.00 | 0.00 | 0.00 | 44.91 |
| Perez, Katherine, J,22079 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Wang, Benjamin, R,27454 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Brooks, Allison,14605 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Walker, Destiny, M,16996 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Roberts, Jordan, M,16800 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Andersen, Latoya, J,29057 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Lee, Samantha, B,27378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Henderson, Olivia,18859 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| James, Julia,24975 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Ross, Kelly,26076 | 76.96 | 0.00 | 0.00 | 0.00 | 76.96 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Garcia, Lucas,27545 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Perry, Lauren,24816 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bradley, Nathaniel,16955 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Foster, Paige,27428 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Price, Rachel, D,25328 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Cook, Joan,23554 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Russell, Caleb,23552 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Peterson, Kaitlyn, S,13706 | 2337.27 | 0.00 | 0.00 | 0.00 | 2337.27 |
| Reed, Megan, A,18118 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Mr., Sandstone, John, J,12903 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Nelson, Katherine,28021 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Coleman, Alexandria, C,13289 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Diaz, Jason,17374 | 206.63 | 0.00 | 0.00 | 89.46 | 117.17 |
| Harris, Anthony,21447 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Richardson, Lauren, C,14867 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Nelson, Sierra,16132 | 2459.62 | 0.00 | 0.00 | 2459.62 | 0.00 |
| _SUM | 1806517.50 | 25543.71 | 493581.21 | 254851.63 | 1032540.95 |
Generated 2025-12-23 14:33:33.452 UTC