[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 250 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Edwards, Alexandra,13358 | 2386.94 | 0.00 | 0.00 | 0.00 | 2386.94 |
| Martin, Xavier,22233 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Howard, Isaiah,25981 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| Bennett, Brittany, J,22332 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bailey, Richard, N,22050 | 4160.53 | 3578.27 | 0.00 | 0.00 | 582.26 |
| Bryant, Isabelle,23397 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Brooks, Paige,22232 | 5985.31 | 0.00 | 3578.27 | 0.00 | 2407.04 |
| Hayes, Gavin, A,19400 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Roberts, Jordan, M,16800 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Perry, Christian,24671 | 4354.60 | 0.00 | 3578.27 | 0.00 | 776.33 |
| Campbell, Evan, W,24342 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Lewis, Zachary, L,14760 | 167.26 | 0.00 | 0.00 | 0.00 | 167.26 |
| Sanz, Lori, L,23865 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Rogers, Jared, J,12166 | 162.22 | 0.00 | 0.00 | 0.00 | 162.22 |
| Srini, Ruben,18078 | 200.94 | 0.00 | 0.00 | 71.97 | 128.97 |
| Edwards, Hunter,24220 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Cooper, Brooke,19536 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Powell, Jack, J,18411 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 0.00 | 272.69 |
| Foster, Jose, C,28785 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Rogers, Carlos,19645 | 134.44 | 0.00 | 0.00 | 0.00 | 134.44 |
| 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 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Carter, Jason,11724 | 210.09 | 0.00 | 0.00 | 113.86 | 96.23 |
| Perry, James,19205 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Bailey, Maria, C,19150 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Stewart, Marcus, R,20632 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Garcia, Xavier, M,20300 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Bennett, Jordyn, L,22230 | 4223.23 | 0.00 | 3578.27 | 0.00 | 644.96 |
| Garcia, Isabella,18382 | 204.94 | 0.00 | 0.00 | 0.00 | 204.94 |
| Allen, Mason,17625 | 2431.95 | 0.00 | 0.00 | 0.00 | 2431.95 |
| Simmons, Adam,25327 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cooper, Grace, C,16012 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| Evans, Connor, J,15402 | 131.55 | 0.00 | 0.00 | 0.00 | 131.55 |
| James, Christina,17409 | 219.92 | 0.00 | 0.00 | 0.00 | 219.92 |
| Russell, Nicole, M,18237 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Hayes, Austin,20208 | 3219.58 | 0.00 | 2049.10 | 0.00 | 1170.48 |
| Diaz, Luke,12054 | 402.53 | 0.00 | 0.00 | 139.97 | 262.56 |
| Jackson, Elizabeth, K,16837 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Alexander, Paige, W,18604 | 59.25 | 0.00 | 0.00 | 37.27 | 21.98 |
| Howard, Danielle,28357 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Thompson, Kayla, D,12363 | 273.90 | 0.00 | 0.00 | 0.00 | 273.90 |
| Kelly, Angel, E,15418 | 232.23 | 0.00 | 0.00 | 0.00 | 232.23 |
| Diaz, Faith, M,22363 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Sanchez, Shelby,16021 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gonzales, Paige,21702 | 91.94 | 0.00 | 0.00 | 39.98 | 51.96 |
| Martinez, Jill,24235 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Peterson, Brian,12892 | 419.47 | 0.00 | 0.00 | 156.27 | 263.20 |
| Martinez, Matthew, L,16009 | 170.45 | 0.00 | 0.00 | 0.00 | 170.45 |
| Phillips, Andrea,18573 | 83.74 | 0.00 | 0.00 | 0.00 | 83.74 |
| Reed, Sean, L,14597 | 4803.31 | 0.00 | 0.00 | 0.00 | 4803.31 |
| Adams, Gabriel, S,19527 | 1219.45 | 0.00 | 0.00 | 0.00 | 1219.45 |
| Bradley, Nathaniel,16955 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Butler, Jackson, J,18324 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Jones, Alexander, I,20021 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Garcia, Hunter, J,21305 | 3204.58 | 0.00 | 0.00 | 2049.10 | 1155.48 |
| Lee, Ian,19646 | 197.04 | 0.00 | 0.00 | 0.00 | 197.04 |
| Allen, Madeline,29240 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Griffin, Jennifer, B,14244 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
Generated 2025-11-02 05:45:02.731 UTC