[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 78 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Navarro, Janet, J,28320 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Martinez, Daniel, P,17725 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Ramos, Sabrina, L,29082 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Kumar, Derek, M,15135 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 |
| Ramos, Mary, B,15019 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Guo, Rosa, M,24474 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 0.00 | 2071.42 | 4749.05 |
| Rodriguez, Frederick, S,24458 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Shen, Russell, M,11150 | 192.42 | 0.00 | 0.00 | 0.00 | 192.42 |
| Hall, Jesse,26133 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Sanchez, Lydia, S,12579 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 0.00 | 2071.42 | 4734.05 |
Generated 2026-01-04 05:12:55.273 UTC