[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yang, Justin, S,15363 | 4719.04 | 0.00 | 0.00 | 0.00 | 4719.04 |
| Johnson, Jeremiah, A,14446 | 146.75 | 0.00 | 0.00 | 14.98 | 131.77 |
| Alexander, Logan, E,19116 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Russell, Kaitlyn, M,24491 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Perry, Jennifer, J,22120 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Cooper, Angela,19526 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Foster, Olivia,23806 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
| Smith, Tyler, J,20341 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Chen, Jonathan, G,13096 | 200.69 | 0.00 | 0.00 | 0.00 | 200.69 |
| Flores, Jordyn,25288 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Moore, Anthony, M,24730 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Jason,17374 | 206.63 | 0.00 | 0.00 | 89.46 | 117.17 |
| Lewis, Ethan,27998 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Coleman, Wyatt, M,23284 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bailey, Mariah, L,27243 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Ross, Haley, T,25361 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2049.10 | 598.97 |
| Carter, Marcus, l,21471 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Davis, Emily,27267 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 0.00 | 180.79 |
| Patterson, Natalie,16123 | 629.97 | 0.00 | 0.00 | 0.00 | 629.97 |
| Rogers, Carlos,19645 | 134.44 | 0.00 | 0.00 | 0.00 | 134.44 |
| Stewart, Cindy,14496 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Hayes, Jason,26176 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Adams, Katherine, M,23518 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Taylor, Taylor,15905 | 4899.02 | 0.00 | 0.00 | 0.00 | 4899.02 |
| Bryant, Brittany,22545 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Jones, Samantha,18317 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Hayes, Arianna,25991 | 2845.52 | 0.00 | 0.00 | 2181.56 | 663.96 |
| Price, Caroline,18051 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Taylor, Marcus, A,18944 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Green, Chloe, J,14658 | 92.82 | 0.00 | 0.00 | 0.00 | 92.82 |
| Hughes, Stephanie,26316 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Carter, Luis, E,25883 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Rodriguez, Natalie,20773 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Carter, Savannah, M,12090 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Walker, Ian,16771 | 104.55 | 0.00 | 0.00 | 0.00 | 104.55 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Diaz, Elijah,20000 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Gill, Beth,19997 | 5814.98 | 0.00 | 3374.99 | 0.00 | 2439.99 |
| James, Juan,23267 | 4862.09 | 0.00 | 3578.27 | 0.00 | 1283.82 |
| Cooper, Grace, C,16012 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 49.97 | 121.50 |
| Richardson, Erin, R,16331 | 88.85 | 0.00 | 0.00 | 0.00 | 88.85 |
| Cox, Devin, C,13418 | 4768.05 | 0.00 | 0.00 | 0.00 | 4768.05 |
| Davis, Dylan,15556 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ross, Isabelle, D,18554 | 155.45 | 0.00 | 0.00 | 0.00 | 155.45 |
| Phillips, Andrea,18573 | 83.74 | 0.00 | 0.00 | 0.00 | 83.74 |
| Russell, Oscar, A,12140 | 118.17 | 0.00 | 0.00 | 0.00 | 118.17 |
| Smith, Lucas, P,18090 | 64.91 | 0.00 | 0.00 | 0.00 | 64.91 |
| Howard, Alyssa, A,11513 | 863.95 | 0.00 | 0.00 | 0.00 | 863.95 |
| Davis, Austin, E,13366 | 4749.04 | 0.00 | 0.00 | 0.00 | 4749.04 |
| Brown, Isabella, L,26692 | 1266.86 | 0.00 | 699.10 | 0.00 | 567.76 |
| Roberts, Jordan, M,16800 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Collins, Luis, J,22765 | 5978.61 | 0.00 | 3578.27 | 0.00 | 2400.34 |
| Thompson, Madison, L,18788 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Gonzales, Arianna, S,19710 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Thompson, Tyler,27502 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Lee, John,19801 | 193.01 | 0.00 | 0.00 | 0.00 | 193.01 |
| Jackson, Andrew,20479 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Baker, Allison,26495 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Barnes, Haley, J,21339 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Washington, Elijah, L,25016 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Richardson, Nathaniel,12089 | 4710.03 | 0.00 | 0.00 | 2316.97 | 2393.06 |
| Roberts, Carlos,23196 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Tang, Carl,21238 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Thompson, Kaitlyn, L,12430 | 223.93 | 0.00 | 0.00 | 0.00 | 223.93 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Flores, Brittany,16906 | 2359.98 | 0.00 | 0.00 | 0.00 | 2359.98 |
| Gonzalez, Logan, J,17483 | 64.50 | 0.00 | 0.00 | 0.00 | 64.50 |
| James, Emma,12781 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Phillips, Luis, G,20734 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Johnson, Jonathan,22059 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lewis, Ryan, A,20312 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Campbell, Lucas,29329 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Ortega, Sheila, M,27632 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Isabelle, A,15526 | 188.32 | 0.00 | 0.00 | 0.00 | 188.32 |
| Peterson, Mason, A,18570 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Smith, Samuel, D,23083 | 49.90 | 0.00 | 0.00 | 0.00 | 49.90 |
| Perry, Oscar,22785 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Martin, Noah, A,17657 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Russell, Chloe, M,12763 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Campbell, Alex,11984 | 4730.32 | 0.00 | 0.00 | 0.00 | 4730.32 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Jai, Kevin,19836 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Diaz, Richard, A,26682 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Carter, Jonathan,14578 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Lal, Jonathan,20096 | 71.46 | 0.00 | 0.00 | 0.00 | 71.46 |
| Blue, Makayla,19000 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Johnson, James,23498 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Morgan, Evan, G,14725 | 318.83 | 0.00 | 0.00 | 0.00 | 318.83 |
| Bailey, Maria, C,19150 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Morris, Mason, J,22349 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Rodriguez, Anthony, G,23829 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Evans, Connor, J,15402 | 131.55 | 0.00 | 0.00 | 0.00 | 131.55 |
| Coleman, Joan, W,26699 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Hill, Alexandra, K,15172 | 215.45 | 0.00 | 0.00 | 36.27 | 179.18 |
| Richardson, Arianna, C,12055 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Barnes, Jeremy,21446 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| King, Sara,22354 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nelson, Luis,23488 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Murphy, Chase, J,24729 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Ramirez, Ian,16678 | 3162.31 | 0.00 | 0.00 | 0.00 | 3162.31 |
| Anderson, Lucas,29266 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Elizabeth, F,12782 | 2400.95 | 0.00 | 0.00 | 0.00 | 2400.95 |
| Griffin, Cassidy,26496 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Walker, Brandon, J,15916 | 4793.27 | 0.00 | 0.00 | 0.00 | 4793.27 |
| Martinez, Joseph, E,29214 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Phillips, Aaron, R,24947 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Eduardo, S,28969 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 0.00 | 4693.04 |
| Diaz, Brandon,23676 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sharma, Jackson,16876 | 151.84 | 0.00 | 0.00 | 0.00 | 151.84 |
| Rogers, Andrea, L,14328 | 308.66 | 0.00 | 0.00 | 0.00 | 308.66 |
| Simmons, David, E,12017 | 2339.97 | 0.00 | 0.00 | 0.00 | 2339.97 |
| Li, Rafael, M,21752 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Washington, Miranda,15201 | 4793.02 | 0.00 | 0.00 | 0.00 | 4793.02 |
| Phillips, Devin,18759 | 112.06 | 0.00 | 0.00 | 0.00 | 112.06 |
| Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-21 21:01:45.402 UTC