[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 500 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Tang, Cristina, D,19623 | 153.93 | 0.00 | 0.00 | 0.00 | 153.93 | 0.00 |
| Navarro, Carolyn,11069 | 8104.05 | 0.00 | 3399.99 | 0.00 | 4704.06 | 0.00 |
| Luo, Jenny, L,19474 | 1589.75 | 0.00 | 0.00 | 782.99 | 806.76 | 0.00 |
| Perry, Justin, E,16758 | 3062.34 | 0.00 | 0.00 | 0.00 | 3062.34 | 0.00 |
| Chapman, Kari, M,26221 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Gill, Byron, J,18483 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Hall, Lucas,28760 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 | 0.00 |
| Cook, Xavier,24633 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 | 0.00 |
| Jimenez, Marie, C,24176 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 | 0.00 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 | 0.00 |
| Flores, Jasmine,20540 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 | 0.00 |
| Carlson, Gina, R,20521 | 25.22 | 0.00 | 0.00 | 0.00 | 25.22 | 0.00 |
| Anderson, Xavier,17086 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 | 0.00 |
| Gutierrez, Gina, A,21092 | 2511.26 | 0.00 | 0.00 | 782.99 | 1728.27 | 0.00 |
| Nara, Roger,26928 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 | 0.00 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 | 0.00 |
| Scott, Xavier,14764 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Miller, Olivia, H,26860 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 | 0.00 |
| Miller, Zachary, M,15169 | 2919.89 | 0.00 | 0.00 | 2071.42 | 848.47 | 0.00 |
| Srini, Erick, H,17947 | 3932.54 | 0.00 | 0.00 | 2181.56 | 1750.98 | 0.00 |
| Jai, Lindsey, W,23971 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 | 0.00 |
| Zhu, Leah,22474 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 | 0.00 |
| Robinson, Justin, A,23289 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 | 0.00 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 | 0.00 |
| Ms., Li, Amy, J,12592 | 51.96 | 0.00 | 0.00 | 0.00 | 51.96 | 0.00 |
| Vazquez, Theresa, F,22581 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 | 0.00 |
| Ruiz, Melody,13621 | 167.40 | 0.00 | 0.00 | 0.00 | 167.40 | 0.00 |
| Romero, Reginald, F,12854 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 | 0.00 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 | 0.00 |
| Gutierrez, Alberto, R,15461 | 88.96 | 0.00 | 0.00 | 0.00 | 88.96 | 0.00 |
| Yuan, Colin,11758 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 | 0.00 |
Generated 2026-01-04 05:08:15.354 UTC