[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 73 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Pal, Peter, K,22848 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Xu, Tara,19592 | 5377.23 | 0.00 | 3578.27 | 0.00 | 1798.96 |
| Suri, Kristopher, M,22849 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Jai, Rafael, L,17323 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Subram, Meredith, S,14261 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Clark, Madison, A,14062 | 5647.92 | 0.00 | 0.00 | 2049.10 | 3598.82 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Gutierrez, Clinton,21001 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| She, Rosa,18931 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| King, Maria, E,28202 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Adams, Sydney,27367 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Mr., Solanki, Ajay,18295 | 144.27 | 0.00 | 0.00 | 0.00 | 144.27 |
| Gutierrez, Victor, J,27357 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nath, Tasha, J,18487 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Prasad, Jarrod,11359 | 4960.07 | 0.00 | 3374.99 | 0.00 | 1585.08 |
| Schmidt, Kaitlin,13628 | 191.25 | 0.00 | 0.00 | 0.00 | 191.25 |
| Martinez, Ethan, C,20260 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Black, Rafael,11966 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Chandra, Jarrod,24171 | 3006.31 | 0.00 | 0.00 | 2443.35 | 562.96 |
| Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Xie, Marshall, M,19796 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gutierrez, Adrienne,18906 | 4217.22 | 0.00 | 3578.27 | 638.95 | 0.00 |
| Goel, Carl, S,17249 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Martinez, Heidi, L,22922 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Garcia, Carolyn,20999 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Jai, Tasha, A,19771 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Gonzalez, Roy, M,13040 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
Generated 2025-12-21 13:35:16.292 UTC