[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Nelson, Julia, L,11102 | 102.91 | 0.00 | 0.00 | 0.00 | 102.91 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Hu, Aimee, R,27981 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Ray, Bobby,23575 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Moreno, Randall, F,21209 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Cai, Steve, M,22155 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhou, Clayton,27348 | 1382.46 | 0.00 | 0.00 | 782.99 | 599.47 |
| Martin, Hector,27860 | 615.47 | 0.00 | 0.00 | 0.00 | 615.47 |
| Butler, Destiny,27865 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Lopez, Brenda,26592 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Xu, Kelvin,18305 | 160.55 | 0.00 | 0.00 | 0.00 | 160.55 |
| Shan, Sheena, J,21565 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Martinez, Douglas, C,22841 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Chow, Shannon,18444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Ramos, Jessie, R,11764 | 8129.02 | 0.00 | 3399.99 | 0.00 | 4729.03 |
| Kumar, Jaime, O,29061 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Chander, Yolanda,16519 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Gill, Gerald, A,28487 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Lal, Leonard,26160 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Blanco, Erika, L,14669 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Navarro, Erik, E,25055 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Vance, Toni, L,23438 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| Gutierrez, Latasha, C,15022 | 2999.91 | 0.00 | 0.00 | 2071.42 | 928.49 |
| Nelson, Sophia,16664 | 4377.75 | 0.00 | 3578.27 | 799.48 | 0.00 |
| Shen, Franklin,27144 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Allen, Luis, C,26019 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Rodriguez, Cynthia, E,22206 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Martinez, Monica, A,14129 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
Generated 2025-12-21 13:34:45.288 UTC