[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 22 < SKIP 3500 > < TAKE 125 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Garcia, Tina,17231 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Navarro, Carolyn,11069 | 8104.05 | 0.00 | 3399.99 | 2319.99 | 2384.07 |
| Diaz, Aaron, C,18695 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Ma, Louis,21879 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Zhang, Susan, S,18216 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Nath, Keith,19617 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Martinez, Tina, J,18461 | 4748.24 | 0.00 | 3578.27 | 0.00 | 1169.97 |
| Jai, Latoya, S,21229 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| She, Mindy, J,13009 | 168.67 | 0.00 | 0.00 | 0.00 | 168.67 |
| Long, Nicole, C,13624 | 114.97 | 0.00 | 0.00 | 0.00 | 114.97 |
| Diaz, Roberto, A,22202 | 4671.74 | 0.00 | 0.00 | 2181.56 | 2490.18 |
| Alexander, Olivia, L,14667 | 5295.41 | 0.00 | 0.00 | 2049.10 | 3246.31 |
| Johnson, Emma, M,15136 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Chander, Marshall,19090 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
Generated 2025-12-23 05:49:27.222 UTC