[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 496 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Williams, Ethan,24309 | 4793.12 | 0.00 | 3578.27 | 0.00 | 1214.85 |
| Thomas, Matthew, K,13239 | 185.70 | 0.00 | 0.00 | 0.00 | 185.70 |
| Allen, Aaron, A,20075 | 3399.99 | 0.00 | 3399.99 | 0.00 | 0.00 |
| Long, Rachel,28283 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mitchell, Katelyn, A,24496 | 4349.61 | 0.00 | 3578.27 | 0.00 | 771.34 |
| Griffin, James,28189 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Morgan, Abigail, C,24431 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 |
| Yang, Jordan, K,14458 | 133.95 | 0.00 | 0.00 | 0.00 | 133.95 |
| Simmons, Elizabeth, A,21461 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Chen, Jack, E,17579 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Richardson, Melissa, E,11132 | 2371.94 | 0.00 | 0.00 | 0.00 | 2371.94 |
| Walker, John, M,28589 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lu, Alejandro,25620 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Watson, Emma,17481 | 126.94 | 0.00 | 0.00 | 0.00 | 126.94 |
| Rogers, Andrea, L,14328 | 308.66 | 0.00 | 0.00 | 0.00 | 308.66 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 0.00 | 213.52 |
| Hall, Grace, A,20189 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Anderson, Ryan, W,13271 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Umeda, Masaki,16717 | 233.81 | 0.00 | 0.00 | 0.00 | 233.81 |
| Jackson, Brianna,15377 | 97.91 | 0.00 | 0.00 | 0.00 | 97.91 |
| Price, Oscar, G,11833 | 240.01 | 0.00 | 0.00 | 0.00 | 240.01 |
| Green, Xavier,23567 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hall, Eduardo,16847 | 189.94 | 0.00 | 0.00 | 0.00 | 189.94 |
| Wang, Karen, P,19553 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Morgan, Juan, C,18821 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Foster, Alyssa, I,14875 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Simmons, Mariah,26683 | 1270.82 | 0.00 | 699.10 | 0.00 | 571.72 |
| Bryant, Connor,23842 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Gonzales, Ryan, M,17373 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Richardson, Caitlin, T,23057 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Collins, Xavier, C,16646 | 250.91 | 0.00 | 0.00 | 0.00 | 250.91 |
| Hughes, Morgan, T,11642 | 392.89 | 0.00 | 0.00 | 0.00 | 392.89 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Campbell, Angel, D,19546 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Brooks, Paige,22232 | 5985.31 | 0.00 | 3578.27 | 0.00 | 2407.04 |
| Lee, John,19801 | 193.01 | 0.00 | 0.00 | 0.00 | 193.01 |
| Rogers, Jared, J,12166 | 162.22 | 0.00 | 0.00 | 0.00 | 162.22 |
| Srini, Ruben,18078 | 200.94 | 0.00 | 0.00 | 0.00 | 200.94 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 0.00 | 634.84 |
| Miller, Joseph, A,22713 | 4148.19 | 0.00 | 3578.27 | 0.00 | 569.92 |
| Collins, Charles, B,29041 | 628.45 | 0.00 | 0.00 | 0.00 | 628.45 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 0.00 | 603.53 |
| Scott, Kaitlyn, A,12159 | 218.91 | 0.00 | 0.00 | 0.00 | 218.91 |
| James, Emma,12781 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Cooper, Brooke,19536 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Powell, Jack, J,18411 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Shan, Christian, L,23084 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Smith, Andrew,14723 | 87.57 | 0.00 | 0.00 | 0.00 | 87.57 |
| Brown, Benjamin, D,15187 | 4725.32 | 0.00 | 0.00 | 0.00 | 4725.32 |
| Simmons, Anna, K,12451 | 2367.92 | 0.00 | 0.00 | 0.00 | 2367.92 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 34.89 | 66.96 |
| Raman, Emmanuel, W,19554 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Wood, Gabrielle, S,28787 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Allen, Mason,17625 | 2431.95 | 0.00 | 0.00 | 0.00 | 2431.95 |
| Richardson, Devin, G,21318 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Ortega, Sheila, M,27632 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rivera, Hailey, R,20792 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Brooks, Jacqueline, W,28254 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Morgan, Andrea, M,16870 | 149.04 | 0.00 | 0.00 | 39.47 | 109.57 |
Generated 2025-12-23 11:31:54.519 UTC