[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 1 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Torres, Mackenzie,28153 | 570.47 | 0.00 | 0.00 | 0.00 | 570.47 |
| Wright, Kyle,23716 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Simmons, Nicole, S,26177 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Roberts, Thomas, J,21939 | 4163.24 | 3578.27 | 0.00 | 0.00 | 584.97 |
| Lal, Kyle,17360 | 122.18 | 0.00 | 0.00 | 0.00 | 122.18 |
| Taylor, Taylor,15905 | 4899.02 | 0.00 | 0.00 | 0.00 | 4899.02 |
| Anderson, Destiny,12895 | 336.65 | 0.00 | 0.00 | 37.27 | 299.38 |
| Foster, Jessica,26069 | 51.46 | 0.00 | 0.00 | 51.46 | 0.00 |
| Griffin, Melissa, L,28780 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Flores, Zachary, H,23376 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 213.86 | 911.50 |
| Yang, Justin, S,15363 | 4719.04 | 0.00 | 0.00 | 0.00 | 4719.04 |
| Perry, Jennifer, J,22120 | 5962.34 | 0.00 | 3578.27 | 2384.07 | 0.00 |
| Barnes, Haley, J,21339 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Evans, Luke,29176 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 196.04 | 959.86 |
| Parker, Jennifer, D,22118 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Hayes, Jeremiah, W,20086 | 128.55 | 0.00 | 0.00 | 56.97 | 71.58 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 219.26 | 789.98 |
| Evans, James, C,20665 | 4408.56 | 0.00 | 0.00 | 2049.10 | 2359.46 |
| Allen, Aaron, A,20075 | 3399.99 | 0.00 | 3399.99 | 0.00 | 0.00 |
| Bennett, Jennifer, G,13708 | 123.94 | 0.00 | 0.00 | 68.97 | 54.97 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Nelson, Kevin,14765 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Sanchez, Shelby,16021 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Mitchell, Lucas, C,19829 | 4533.45 | 3374.99 | 0.00 | 0.00 | 1158.46 |
| Sanders, Alexa, E,21741 | 4127.25 | 3578.27 | 0.00 | 548.98 | 0.00 |
| Reed, Gabriella, A,27437 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hughes, Stephanie,26316 | 1000.44 | 0.00 | 1000.44 | 0.00 | 0.00 |
| Ross, Miranda,14598 | 4839.00 | 0.00 | 0.00 | 0.00 | 4839.00 |
Generated 2025-11-06 07:50:43.827 UTC