[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 8 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yuan, Jon,25937 | 1299.56 | 0.00 | 699.10 | 0.00 | 600.46 |
| Lewis, Nicole,21881 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Rana, Johnathan, R,27497 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Perez, Henry,26752 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Zhang, Damien, C,26758 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Zheng, Cara, L,27513 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Shan, Thomas, N,27483 | 1382.46 | 0.00 | 0.00 | 782.99 | 599.47 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 7.95 | 138.96 |
| Zheng, Sandra, P,15141 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Martinez, Terrance,25718 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Diaz, Stacy, L,12340 | 6752.13 | 0.00 | 2049.10 | 0.00 | 4703.03 |
| Wood, Sydney,23310 | 3333.32 | 0.00 | 0.00 | 3333.32 | 0.00 |
| Wood, Julia, L,12356 | 6810.13 | 0.00 | 2049.10 | 0.00 | 4761.03 |
| Navarro, Javier,14131 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
Generated 2025-12-21 17:28:39.420 UTC