[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 92 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Srini, Kristopher, A,23997 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carlson, Joanna,15594 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 2049.10 | 4913.04 |
| Rubio, Desiree, D,21189 | 4208.31 | 0.00 | 2443.35 | 0.00 | 1764.96 |
| Alonso, Lance, I,14057 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Lin, Jaclyn,28721 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alonso, Stacy,28315 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Arthur, Joel,27701 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Moreno, Mallory, P,22912 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Raji, Wayne, A,26161 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Martinez, Virginia,13136 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Hernandez, Kellie, A,12586 | 2636.41 | 0.00 | 2071.42 | 0.00 | 564.99 |
| Li, Lisa, J,24600 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| She, Jessie, A,13650 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
Generated 2025-12-22 04:19:46.389 UTC