[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 4 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 130.94 | 793.67 |
| Hall, Morgan,21726 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 13.98 | 1111.38 |
| Sanchez, Martin, E,21631 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perez, Sydney, C,22117 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Morris, Abigail, C,28776 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Martin, Xavier,22233 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Dominguez, Meghan,14370 | 122.56 | 0.00 | 0.00 | 0.00 | 122.56 |
| Smith, John,19855 | 5709.96 | 0.00 | 3399.99 | 0.00 | 2309.97 |
| Campbell, Hunter,17422 | 174.92 | 0.00 | 0.00 | 0.00 | 174.92 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Murphy, Richard, M,22299 | 4145.54 | 0.00 | 3578.27 | 0.00 | 567.27 |
| Rogers, Carlos,19645 | 134.44 | 0.00 | 0.00 | 0.00 | 134.44 |
| Rogers, Sara,19874 | 4544.45 | 0.00 | 3374.99 | 0.00 | 1169.46 |
| Brown, Isabella, L,26692 | 1266.86 | 0.00 | 699.10 | 0.00 | 567.76 |
| Carter, Marcus, l,21471 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Miller, Joseph, A,22713 | 4148.19 | 0.00 | 3578.27 | 0.00 | 569.92 |
| Walker, Charles,11677 | 298.21 | 0.00 | 0.00 | 0.00 | 298.21 |
| Perry, Oscar,22785 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 31.27 | 808.88 |
| Thomas, Thomas,21629 | 2624.08 | 0.00 | 0.00 | 2049.10 | 574.98 |
| Collins, Luis, J,22765 | 5978.61 | 0.00 | 3578.27 | 0.00 | 2400.34 |
| Taylor, Ryan,17025 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Perez, Eduardo, M,22895 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Reed, Erin, I,14353 | 128.84 | 0.00 | 0.00 | 0.00 | 128.84 |
| Peterson, Brian,12892 | 419.47 | 0.00 | 0.00 | 0.00 | 419.47 |
| Stewart, Hailey,22903 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Henderson, Jordan, C,22996 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Lewis, Lucas, A,23209 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Bailey, Morgan, E,21354 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Sanchez, Lucas, L,23351 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Wilson, Tyler, L,15879 | 196.93 | 0.00 | 0.00 | 0.00 | 196.93 |
| Patterson, Nicole,19729 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Diaz, Elijah,20000 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Mitchell, Savannah,26115 | 3052.80 | 0.00 | 0.00 | 2443.35 | 609.45 |
| Ware, Dennis, L,23725 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Murphy, Catherine, L,16506 | 92.05 | 0.00 | 0.00 | 0.00 | 92.05 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 0.00 | 1010.56 |
| Hernandez, Jonathan, J,19014 | 65.95 | 0.00 | 0.00 | 0.00 | 65.95 |
| Bryant, Isabelle,23397 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Wilson, Hunter, R,27230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Rogers, Jared, J,12166 | 162.22 | 0.00 | 0.00 | 0.00 | 162.22 |
| Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
| Chander, Wayne, S,24344 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Rogers, Faith,24682 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Bailey, Marcus, L,18329 | 146.53 | 0.00 | 0.00 | 23.78 | 122.75 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Price, Isabelle,20182 | 5749.97 | 0.00 | 3374.99 | 0.00 | 2374.98 |
| Yang, Thomas, A,14108 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| She, Kenneth,16096 | 212.01 | 0.00 | 0.00 | 0.00 | 212.01 |
| Rogers, Sean, G,18685 | 124.46 | 0.00 | 0.00 | 0.00 | 124.46 |
| Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 0.00 | 1381.37 |
| Rivera, Caitlin, L,26113 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Parker, Morgan, S,16772 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Brooks, Jennifer, L,17411 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Robinson, Abigail, R,18379 | 2362.27 | 0.00 | 0.00 | 0.00 | 2362.27 |
| Malhotra, Kristi, S,15175 | 4850.33 | 0.00 | 0.00 | 0.00 | 4850.33 |
| Sharma, Thomas, A,18637 | 121.94 | 0.00 | 0.00 | 0.00 | 121.94 |
| Morris, Richard,20070 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hernandez, Marcus,18595 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Chen, James, D,11641 | 303.20 | 0.00 | 0.00 | 21.49 | 281.71 |
Generated 2025-12-24 05:43:35.014 UTC