[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 92 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhang, Ronnie,16656 | 5930.23 | 0.00 | 3578.27 | 0.00 | 2351.96 |
| Mehta, Brandy,22839 | 39.25 | 0.00 | 0.00 | 39.25 | 0.00 |
| Xu, Tracy, L,17916 | 4787.74 | 0.00 | 3578.27 | 0.00 | 1209.47 |
| He, Gilbert,15589 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Ramos, Jay, D,21882 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Rana, Stefanie, K,19616 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Schmidt, Pamela, I,24375 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Rodriguez, Ruth, R,26179 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Liu, Bianca, K,11458 | 31.92 | 0.00 | 0.00 | 0.00 | 31.92 |
| Rodriguez, Heidi, L,25120 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Goel, Barbara,12988 | 6915.44 | 0.00 | 0.00 | 2049.10 | 4866.34 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
Generated 2025-12-21 20:37:27.645 UTC