[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 19 SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Murphy, Dalton, N,27043 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Moore, Jessica, J,20085 | 76.76 | 0.00 | 0.00 | 0.00 | 76.76 |
| Peterson, Julia, P,16497 | 132.71 | 0.00 | 0.00 | 0.00 | 132.71 |
| Morgan, Angela,24665 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Hughes, Caroline, C,28302 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Coleman, Samuel, N,17450 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Rogers, Carlos,19645 | 134.44 | 0.00 | 0.00 | 0.00 | 134.44 |
| Barnes, Brittany, R,15340 | 156.04 | 0.00 | 0.00 | 0.00 | 156.04 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 0.00 | 226.43 |
| Watson, Cole, A,21768 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Murphy, Olivia, V,20206 | 3204.58 | 0.00 | 2049.10 | 0.00 | 1155.48 |
| Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Thomas, Victoria, A,15536 | 249.53 | 0.00 | 0.00 | 0.00 | 249.53 |
| Wagner, Alexandra, E,23244 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanders, Melissa, R,24284 | 4837.34 | 0.00 | 3578.27 | 0.00 | 1259.07 |
| Washington, Elijah, L,25016 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ross, Jose,27441 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Martinez, Carol, D,17656 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Sharma, Kathryn,20740 | 140.94 | 0.00 | 0.00 | 0.00 | 140.94 |
| Alexander, Thomas,20760 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Hill, Alexandra, K,15172 | 215.45 | 0.00 | 0.00 | 36.27 | 179.18 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Parker, Eduardo, M,12939 | 169.42 | 0.00 | 0.00 | 0.00 | 169.42 |
| Peterson, Melissa, S,24995 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ross, Haley, T,25361 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Gonzales, Ashley, C,18600 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Lu, Alejandro,25620 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramirez, Brian, M,11618 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Jones, Nicole,14504 | 112.27 | 0.00 | 0.00 | 0.00 | 112.27 |
| Flores, Arianna,21727 | 4132.24 | 3578.27 | 0.00 | 0.00 | 553.97 |
| Evans, James, C,20665 | 4408.56 | 0.00 | 0.00 | 2049.10 | 2359.46 |
| Ward, Angela, M,27756 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Allen, Aaron, A,20075 | 3399.99 | 0.00 | 3399.99 | 0.00 | 0.00 |
| Robinson, Ian, D,13852 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Peterson, Mason, A,18570 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Thomas, Matthew, K,13239 | 185.70 | 0.00 | 0.00 | 0.00 | 185.70 |
| Scott, Mason,23551 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Russell, Jacqueline,18391 | 100.96 | 0.00 | 0.00 | 0.00 | 100.96 |
| Smith, Chloe,17619 | 163.92 | 0.00 | 0.00 | 0.00 | 163.92 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Mitchell, Kaylee, R,14566 | 401.49 | 0.00 | 0.00 | 0.00 | 401.49 |
| Robinson, Abigail, R,18379 | 2362.27 | 0.00 | 0.00 | 0.00 | 2362.27 |
| Jai, Hunter, M,28272 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Patterson, Cassidy, A,17586 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 0.00 | 2049.10 | 1197.45 |
| Evans, Jordan,29209 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hall, Jan, M,11740 | 334.12 | 0.00 | 0.00 | 0.00 | 334.12 |
| Foster, Jessica,26069 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Williams, Morgan, C,20373 | 3226.90 | 0.00 | 0.00 | 2071.42 | 1155.48 |
| Hall, Kaylee, E,19751 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Hernandez, Marcus,18595 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Scott, Allison,14497 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Gonzalez, Jeremiah,17468 | 128.91 | 0.00 | 0.00 | 0.00 | 128.91 |
| Perry, Jackson, J,21306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moore, Ian, L,24639 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Price, Rachel, D,25328 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Coleman, Destiny, W,12122 | 4814.04 | 0.00 | 0.00 | 0.00 | 4814.04 |
Generated 2025-12-24 06:03:06.963 UTC