[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhang, Barbara,16338 | 169.43 | 0.00 | 0.00 | 58.47 | 110.96 |
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Allen, Devin,15806 | 102.85 | 0.00 | 0.00 | 0.00 | 102.85 |
| Liu, Omar, L,12252 | 3938.95 | 0.00 | 3374.99 | 0.00 | 563.96 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 7.95 | 71.74 |
| Jai, Derek, E,13613 | 105.22 | 0.00 | 0.00 | 0.00 | 105.22 |
| Ma, Cedric, W,11094 | 157.93 | 0.00 | 0.00 | 0.00 | 157.93 |
| Pal, Kara,24916 | 2169.90 | 0.00 | 0.00 | 1000.44 | 1169.46 |
| Patel, Toni, E,25829 | 1894.07 | 0.00 | 699.10 | 0.00 | 1194.97 |
| Guo, Jaclyn,13119 | 6829.45 | 0.00 | 0.00 | 2071.42 | 4758.03 |
| Moreno, Mallory, P,22912 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Ms., Simon, Britta,25946 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Wang, Arturo, A,27720 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Anand, Calvin, E,28717 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Suarez, Gina,20248 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
Generated 2025-12-21 00:54:49.719 UTC