[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 436 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Young, Courtney,17622 | 2374.98 | 0.00 | 0.00 | 0.00 | 2374.98 |
| Tang, Carl,21238 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Hernandez, José, M,11253 | 696.61 | 0.00 | 0.00 | 0.00 | 696.61 |
| Barnes, Elizabeth, J,24939 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Flores, Stephanie,25992 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| James, Sara,19802 | 3374.99 | 3374.99 | 0.00 | 0.00 | 0.00 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 0.00 | 1010.56 |
| Ward, Emma, W,21796 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Green, Isabella,26620 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 0.00 | 1290.33 |
| Suri, Carolyn, S,12972 | 175.71 | 0.00 | 0.00 | 0.00 | 175.71 |
| Martin, Brianna, M,23583 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Torres, Pedro, E,16958 | 168.02 | 0.00 | 0.00 | 0.00 | 168.02 |
| Ma, Tiffany,21577 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Sydney,27921 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gray, Seth, M,20087 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Reed, Paige,22112 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Watson, Victoria,16125 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Jai, Kevin,19836 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Hughes, Destiny, P,28027 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Murphy, Emma,19844 | 5807.93 | 0.00 | 3374.99 | 0.00 | 2432.94 |
| Campbell, Chloe,11212 | 760.93 | 0.00 | 0.00 | 124.97 | 635.96 |
| Jones, Joshua,18401 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Anderson, Isabella,13743 | 2349.98 | 0.00 | 0.00 | 0.00 | 2349.98 |
| Parker, Jennifer, D,22118 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 49.97 | 121.50 |
| Murphy, Caitlin, L,14910 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Gonzales, Brittany,21710 | 4187.23 | 3578.27 | 0.00 | 0.00 | 608.96 |
| Perry, Jennifer, J,22120 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Ross, Jose,27441 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Generated 2025-12-23 09:10:52.491 UTC