[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 45 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lin, Heather, L,15718 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Deng, Carl,18284 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Gao, Micah, W,25106 | 2170.92 | 0.00 | 0.00 | 1000.44 | 1170.48 |
| Sharma, Donna,11998 | 6962.10 | 0.00 | 3374.99 | 0.00 | 3587.11 |
| Lopez, Ross,18443 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Rai, Rafael, H,18715 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Cai, Roger, A,13002 | 294.94 | 0.00 | 0.00 | 0.00 | 294.94 |
| Zheng, Roger,29321 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| King, Kevin, W,21402 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Allen, Devin,15806 | 102.85 | 0.00 | 0.00 | 0.00 | 102.85 |
| Shen, Jodi, A,22028 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Van, Brett,26166 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Chandra, Rebekah,28486 | 776.33 | 0.00 | 0.00 | 0.00 | 776.33 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 0.00 | 2071.42 | 4779.99 |
Generated 2025-12-22 03:19:44.858 UTC