[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Prasad, Candace, S,22148 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gutierrez, Latasha, C,15022 | 2999.91 | 0.00 | 0.00 | 2071.42 | 928.49 |
| Hall, Haley,27489 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 2294.99 | 2419.06 |
| Huang, Wesley,29320 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 0.00 | 100.25 |
| Madan, Raymond, W,20819 | 4181.76 | 0.00 | 3578.27 | 0.00 | 603.49 |
| Kapoor, Brandy, I,15236 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Anand, Jodi,26129 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Ma, Bianca,19798 | 128.44 | 0.00 | 0.00 | 0.00 | 128.44 |
| Ramos, Roy, A,24482 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Butler, Destiny,27865 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Hernandez, Philip,21193 | 3905.52 | 0.00 | 2181.56 | 0.00 | 1723.96 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Jai, Nichole, R,28348 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Xu, Crystal, E,15754 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 0.00 | 4890.01 |
| Cai, Autumn, O,26163 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Gao, Curtis, D,20429 | 5377.75 | 0.00 | 3578.27 | 0.00 | 1799.48 |
| Suarez, Erika,15120 | 5217.70 | 0.00 | 0.00 | 2049.10 | 3168.60 |
| Prasad, Jarrod,11359 | 4960.07 | 0.00 | 3374.99 | 0.00 | 1585.08 |
| Becker, Grant,21390 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Shen, Roger, G,14011 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Price, Isabella, L,17278 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Gill, Meredith, E,24268 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
Generated 2025-12-21 15:25:26.209 UTC