[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 250 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hall, Devin,27204 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramirez, Charles, J,25956 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Collins, Caleb,22360 | 58.95 | 0.00 | 0.00 | 0.00 | 58.95 |
| Goel, Leonard, C,16644 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Tang, Clayton,21821 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Anderson, Jeremy, J,11285 | 127.76 | 0.00 | 0.00 | 0.00 | 127.76 |
| Campbell, Caleb,11729 | 159.96 | 0.00 | 0.00 | 0.00 | 159.96 |
| Morris, Erin,12195 | 124.41 | 0.00 | 0.00 | 0.00 | 124.41 |
| Guo, Bianca, Y,12110 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Lee, Lauren, D,14477 | 3342.41 | 0.00 | 0.00 | 1000.44 | 2341.97 |
| Xie, Terrence,16199 | 6917.59 | 0.00 | 2181.56 | 0.00 | 4736.03 |
| Garcia, Barry,27433 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| White, Dalton, R,16765 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suarez, Jimmy, J,20143 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Collins, Maria, M,17497 | 1717.26 | 0.00 | 0.00 | 0.00 | 1717.26 |
| Walker, Kayla,27679 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Bryant, Blake, C,15202 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Henderson, Natalie,19273 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suarez, Wendy,22511 | 80.47 | 0.00 | 0.00 | 0.00 | 80.47 |
| Harui, Roger,11509 | 196.29 | 0.00 | 0.00 | 0.00 | 196.29 |
| Zhou, Christy,12435 | 5920.24 | 0.00 | 3578.27 | 0.00 | 2341.97 |
| Madan, Barry,26977 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| Griffin, Devin,26042 | 5759.06 | 0.00 | 3374.99 | 0.00 | 2384.07 |
| Morgan, Hailey, G,22753 | 724.47 | 0.00 | 0.00 | 0.00 | 724.47 |
| Cook, Angel, M,21799 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Rogers, Hailey, L,13861 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Moreno, Julio, C,15953 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Lin, Susan, L,27005 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Xu, Katrina, B,24668 | 2473.04 | 0.00 | 0.00 | 0.00 | 2473.04 |
| Ma, Margaret, G,15061 | 2781.54 | 0.00 | 0.00 | 2181.56 | 599.98 |
| Ma, Alejandro, L,17187 | 3310.41 | 0.00 | 1000.44 | 0.00 | 2309.97 |
Generated 2025-11-07 02:53:50.482 UTC