[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 749 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Thompson, Ethan,19989 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Harris, Megan,23281 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Anderson, Megan, A,23859 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Powell, Blake, J,22371 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ross, Alexia, S,13231 | 247.90 | 0.00 | 0.00 | 0.00 | 247.90 |
| Foster, Trevor, J,28964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Allen, Aaron, A,20075 | 3399.99 | 0.00 | 3399.99 | 0.00 | 0.00 |
| Mitchell, Katelyn, A,24496 | 4349.61 | 0.00 | 3578.27 | 0.00 | 771.34 |
| Morgan, Abigail, C,24431 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 |
| Ramirez, Sydney,26700 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 0.00 | 87.95 |
| 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 |
| Cox, Katelyn, B,21742 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| 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 |
| 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 |
| Russell, Kaitlyn, M,24491 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Washington, Ian, M,24664 | 4368.58 | 0.00 | 3578.27 | 0.00 | 790.31 |
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 0.00 | 676.93 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Martin, Morgan,24832 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Sanders, Paige,25287 | 2983.34 | 0.00 | 2443.35 | 0.00 | 539.99 |
| Lazecky, Petr,25864 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Price, Stephanie,25892 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Lewis, Ryan, A,20312 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Young, Savannah,25971 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| 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 |
| Perez, Kaitlyn, A,12081 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| 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 |
| Wilson, Daniel, K,14281 | 4746.30 | 0.00 | 0.00 | 0.00 | 4746.30 |
| Johnson, Christopher,11979 | 4813.76 | 0.00 | 0.00 | 0.00 | 4813.76 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Alexander, Nathan, A,18795 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Morgan, Angela,24665 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Barnes, Jeremy,21446 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| 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 |
| King, Caleb, J,28986 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Watson, Janet, S,23208 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Dominguez, Erika, C,21251 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Clark, William,29021 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hughes, Miranda,26678 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| 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 |
| Hall, Kaylee, E,19751 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Coleman, Logan,18686 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
Generated 2025-12-23 06:51:19.463 UTC