[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 16 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Jones, Joshua,18401 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Prasad, Donald,15413 | 318.92 | 0.00 | 0.00 | 123.98 | 194.94 |
| Coleman, Stephanie,22264 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 0.00 | 272.69 |
| Zhang, Robert,18855 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Nelson, Katherine,28021 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Simmons, Brittany,29231 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chen, Ethan,20547 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Ward, Juan, H,21595 | 2649.56 | 0.00 | 0.00 | 2049.10 | 600.46 |
| Simmons, Dylan,16133 | 107.85 | 0.00 | 0.00 | 38.88 | 68.97 |
| Powell, Jack, J,18411 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Thompson, Isabella,18756 | 128.41 | 0.00 | 0.00 | 0.00 | 128.41 |
| Blanco, Armando, F,13918 | 2397.95 | 0.00 | 0.00 | 0.00 | 2397.95 |
| Griffin, Marcus,20756 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Gonzales, Trevor, K,16085 | 143.53 | 0.00 | 0.00 | 14.98 | 128.55 |
| Ward, Stephanie, A,27429 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Jai, Kevin,19836 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Smith, Andrew,14723 | 87.57 | 0.00 | 0.00 | 0.00 | 87.57 |
| Adams, Kyle, E,18812 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Griffin, Madison, A,25093 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Peterson, Jessica, M,11868 | 247.01 | 0.00 | 0.00 | 61.97 | 185.04 |
| Patterson, Abigail, H,14478 | 4795.01 | 0.00 | 0.00 | 0.00 | 4795.01 |
| Garcia, Chloe, M,11037 | 2374.23 | 0.00 | 0.00 | 2374.23 | 0.00 |
| Diaz, Jason,17374 | 206.63 | 0.00 | 0.00 | 89.46 | 117.17 |
| Gray, Jesse,14626 | 197.04 | 0.00 | 0.00 | 0.00 | 197.04 |
| Reed, Marcus,14582 | 111.79 | 0.00 | 0.00 | 0.00 | 111.79 |
| Ramirez, Ian,16678 | 3162.31 | 0.00 | 0.00 | 0.00 | 3162.31 |
| Martin, Christian, V,19709 | 197.25 | 0.00 | 0.00 | 0.00 | 197.25 |
| She, Kenneth,16096 | 212.01 | 0.00 | 0.00 | 0.00 | 212.01 |
| Hall, Kyle, J,17491 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Diaz, Katherine, P,11526 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Hayes, Dalton, C,18882 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Hughes, Justin, M,18122 | 2439.99 | 0.00 | 0.00 | 0.00 | 2439.99 |
| Washington, Emma,19123 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Davis, Jasmine, M,26529 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Fernandez, Cesar,20035 | 5694.98 | 0.00 | 3374.99 | 0.00 | 2319.99 |
| Ross, Kelly,26076 | 76.96 | 0.00 | 0.00 | 0.00 | 76.96 |
| Ward, Natalie, J,13241 | 2325.96 | 0.00 | 0.00 | 0.00 | 2325.96 |
| Bailey, Marcus, L,18329 | 146.53 | 0.00 | 0.00 | 23.78 | 122.75 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 0.00 | 275.50 |
| Zhang, Heather,16654 | 3056.32 | 0.00 | 0.00 | 0.00 | 3056.32 |
| Garcia, Victoria, V,24501 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Williams, Ryan, R,22247 | 5978.61 | 0.00 | 3578.27 | 0.00 | 2400.34 |
| Phillips, Kaylee,21138 | 4371.38 | 0.00 | 0.00 | 2049.10 | 2322.28 |
| Mr., Sandstone, John, J,12903 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Brooks, Ian, W,28290 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Barnes, Dalton, C,17858 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Morgan, Timothy,14633 | 242.50 | 0.00 | 0.00 | 0.00 | 242.50 |
| Suarez, Juan, R,16763 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Thomas, Dalton,23009 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Washington, Robert, J,14906 | 143.95 | 0.00 | 0.00 | 0.00 | 143.95 |
| Reed, Gabriella, A,27437 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gray, Jared, A,26449 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-21 17:36:36.727 UTC