[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 28 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yuan, Alicia,25225 | 2129.92 | 0.00 | 0.00 | 1000.44 | 1129.48 |
| Shen, Brendan, L,14305 | 3652.20 | 0.00 | 0.00 | 2049.10 | 1603.10 |
| Munoz, Meredith,13957 | 5645.24 | 0.00 | 0.00 | 2071.42 | 3573.82 |
| Sun, Jaclyn,18211 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Stone, Mitchell,25013 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Ye, Ramon,11357 | 4943.80 | 0.00 | 3374.99 | 0.00 | 1568.81 |
| Torres, Joanna, E,24464 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Powell, Aaron,25241 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martinez, Ian,12585 | 2629.07 | 0.00 | 0.00 | 2049.10 | 579.97 |
| Anand, Lacey, J,27150 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Martinez, Lydia,24169 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Kapoor, Dominic, J,16699 | 67.58 | 0.00 | 0.00 | 0.00 | 67.58 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Nara, Leonard, G,11045 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Liu, Candice,28720 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 0.00 | 2484.94 |
| Sun, Candice, A,19568 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Raman, César, C,24004 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Raman, Arthur,24001 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Rai, Grant, R,12573 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Zeng, Louis,18903 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Prasad, Brandy, P,14009 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Sai, Preston, D,17046 | 4467.74 | 0.00 | 3578.27 | 0.00 | 889.47 |
Generated 2025-12-22 02:07:22.461 UTC