[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 311 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| King, Connor,26106 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 |
| Sharma, Rafael, B,12200 | 5935.55 | 0.00 | 3578.27 | 0.00 | 2357.28 |
| Gray, Arianna,14914 | 1592.57 | 0.00 | 699.10 | 0.00 | 893.47 |
| Ramirez, Amanda, E,15017 | 1307.06 | 0.00 | 699.10 | 607.96 | 0.00 |
| Wright, Kevin, A,26096 | 5843.54 | 0.00 | 3399.99 | 0.00 | 2443.55 |
| Ortega, Jamie,14978 | 4209.21 | 0.00 | 3578.27 | 0.00 | 630.94 |
| Zhang, Thomas, H,12769 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Smith, Tammy, L,13555 | 6484.45 | 0.00 | 3578.27 | 0.00 | 2906.18 |
| Moore, Benjamin, D,12913 | 5922.53 | 0.00 | 3578.27 | 0.00 | 2344.26 |
| Shan, Ethan,12178 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Flores, Natalie,16732 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Srini, Bryant, P,12186 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Morris, Brianna, P,12912 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Romero, Erik, R,29403 | 616.95 | 0.00 | 0.00 | 0.00 | 616.95 |
| Alvarez, Latasha,18047 | 2736.42 | 0.00 | 1000.44 | 0.00 | 1735.98 |
| Cai, Lisa,11241 | 11469.19 | 0.00 | 0.00 | 4379.08 | 7090.11 |
| Tang, Tony, C,19930 | 3115.27 | 0.00 | 782.99 | 0.00 | 2332.28 |
| Ma, Trisha, E,13039 | 3282.83 | 0.00 | 2443.35 | 0.00 | 839.48 |
| Simmons, Ethan,13210 | 4501.55 | 0.00 | 2181.56 | 0.00 | 2319.99 |
| Gill, Micheal,25593 | 1264.84 | 0.00 | 0.00 | 0.00 | 1264.84 |
| Munoz, Erika,15114 | 6918.87 | 0.00 | 2181.56 | 0.00 | 4737.31 |
| Harris, Daniel, T,13085 | 3089.80 | 0.00 | 2443.35 | 0.00 | 646.45 |
| Garcia, Andrew, J,23242 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Coleman, Tristan,15883 | 89.95 | 0.00 | 0.00 | 0.00 | 89.95 |
| Chandra, Brenda,15100 | 6952.58 | 0.00 | 2181.56 | 0.00 | 4771.02 |
| Chande, Calvin, E,11483 | 4966.39 | 0.00 | 0.00 | 4426.40 | 539.99 |
| Alvarez, Robyn, M,12255 | 2304.98 | 0.00 | 0.00 | 0.00 | 2304.98 |
| Moyer, Max, C,12980 | 4552.52 | 0.00 | 2181.56 | 0.00 | 2370.96 |
| Powell, Destiny,13057 | 3341.81 | 0.00 | 2443.35 | 0.00 | 898.46 |
| Foster, Jason, A,12934 | 4551.53 | 0.00 | 2181.56 | 0.00 | 2369.97 |
Generated 2025-12-24 06:18:21.748 UTC