[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 795 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 0.00 | 87.95 |
| Yuan, Carly,19839 | 194.96 | 0.00 | 0.00 | 0.00 | 194.96 |
| Allen, Mason,17625 | 2431.95 | 0.00 | 0.00 | 0.00 | 2431.95 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 0.00 | 108.54 |
| Isla, Julian, A,13732 | 108.96 | 0.00 | 0.00 | 0.00 | 108.96 |
| Coleman, Miguel, D,27400 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Yuan, Yolanda, C,22154 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Rubio, Ruben, D,18871 | 86.96 | 0.00 | 0.00 | 0.00 | 86.96 |
| Ross, Jose,27441 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Chavez, Kara, P,13285 | 214.35 | 0.00 | 0.00 | 0.00 | 214.35 |
| Harris, Jacob, G,23679 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Simmons, Dylan,16133 | 107.85 | 0.00 | 0.00 | 0.00 | 107.85 |
| Gonzales, Trevor, K,16085 | 143.53 | 0.00 | 0.00 | 0.00 | 143.53 |
| Moore, Logan,26348 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Diaz, Aidan, L,23846 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Smith, Noah,13175 | 166.92 | 0.00 | 0.00 | 0.00 | 166.92 |
| James, Christina,17409 | 219.92 | 0.00 | 0.00 | 0.00 | 219.92 |
| Wright, Katelyn, A,14502 | 122.26 | 0.00 | 0.00 | 0.00 | 122.26 |
| Griffin, Jordan,13095 | 328.89 | 0.00 | 0.00 | 0.00 | 328.89 |
| Turner, Samuel,27420 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhang, Connor, R,13853 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Rogers, Sean, G,18685 | 124.46 | 0.00 | 0.00 | 0.00 | 124.46 |
| Gray, Sebastian, B,13878 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Walker, Jacob, N,29027 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Thomas, Edward, E,19147 | 133.71 | 0.00 | 0.00 | 0.00 | 133.71 |
| Malhotra, Brenda,13391 | 2405.47 | 0.00 | 0.00 | 0.00 | 2405.47 |
| James, Emma,12781 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Rodriguez, Joshua, A,23511 | 4843.11 | 0.00 | 3578.27 | 0.00 | 1264.84 |
| Cooper, Brooke,19536 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 0.00 | 214.26 |
| Brooks, Victoria, H,16479 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Nath, Yolanda, A,24625 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 0.00 | 846.77 |
| Kelly, Bailey, R,28284 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Griffin, Jennifer, B,14244 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Gutierrez, Neil, L,21489 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thomas, Isabella, M,27265 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ward, Lucas, N,18363 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Lewis, Isabella,26242 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Cooper, Christina, C,26512 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Gomez, Briana, A,28784 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Butler, Morgan, E,20500 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Russell, Gail, L,21263 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Robinson, Jennifer, L,26504 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Taylor, Edward, C,17442 | 319.88 | 0.00 | 0.00 | 0.00 | 319.88 |
| Simmons, Dakota, T,14110 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| White, James,25331 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Morris, Haley, A,23548 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Sharma, Jackson,16876 | 151.84 | 0.00 | 0.00 | 0.00 | 151.84 |
| Washington, Ryan,28332 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Cox, Julia, A,20670 | 3228.57 | 0.00 | 0.00 | 2049.10 | 1179.47 |
| Brooks, Jacqueline, W,28254 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Smith, Justin, P,19827 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Gonzalez, Morgan,13065 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Anderson, Ashley,20680 | 3219.58 | 0.00 | 0.00 | 2049.10 | 1170.48 |
| Allen, Sean, L,12097 | 159.22 | 0.00 | 0.00 | 0.00 | 159.22 |
Generated 2026-01-04 05:19:39.875 UTC