[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 500 < SKIP 75 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wright, Jennifer,26505 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Evans, Maria,22544 | 127.28 | 0.00 | 0.00 | 0.00 | 127.28 |
| Hall, Jose, J,17601 | 225.42 | 0.00 | 0.00 | 0.00 | 225.42 |
| Stewart, Garrett, O,15762 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Washington, Hannah, A,29130 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Russell, Rachel, C,21581 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Hill, Timothy,14871 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Nelson, Kevin,14765 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Long, Elizabeth, F,12782 | 2400.95 | 0.00 | 0.00 | 0.00 | 2400.95 |
| Sanders, Stephanie, A,19746 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Rivera, Kaitlyn, R,15490 | 4813.52 | 0.00 | 0.00 | 0.00 | 4813.52 |
| Bailey, Alexandria, V,13209 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Robinson, Zachary, L,13709 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Brown, Morgan,29197 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Jai, Hunter, M,28272 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Martin, Jeremiah, E,17345 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Mr., Sandstone, John, J,12903 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Ruiz, Carrie, D,18644 | 135.44 | 0.00 | 0.00 | 0.00 | 135.44 |
| Nelson, Katherine,28021 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Alexander, Julia, J,15291 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
| Cooper, Jacqueline, S,27634 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Alexander, Caroline,17654 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Nath, Alison, J,17116 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
| Ramirez, Brian, M,11618 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Chen, Luis, G,21252 | 94.45 | 0.00 | 0.00 | 0.00 | 94.45 |
| Bell, Timothy, J,28101 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Harris, Natalie,23682 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ward, Kaylee, A,24415 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Taylor, Taylor,15905 | 4899.02 | 0.00 | 0.00 | 0.00 | 4899.02 |
Generated 2026-01-04 05:48:15.153 UTC