[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 77 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ramos, Naomi, M,23656 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Vazquez, Marvin, K,21953 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Shen, Nichole,12999 | 6840.46 | 0.00 | 0.00 | 2071.42 | 4769.04 |
| Ray, Bobby,23575 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Allen, Logan,15812 | 81.25 | 0.00 | 0.00 | 0.00 | 81.25 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Sun, Candice, A,19568 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Zeng, Tiffany, B,21890 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Gutierrez, Adrienne,18906 | 4217.22 | 0.00 | 3578.27 | 638.95 | 0.00 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Sun, Tamara, L,19976 | 44.04 | 0.00 | 0.00 | 0.00 | 44.04 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Lopez, Carmen, S,13528 | 4531.04 | 0.00 | 0.00 | 2071.42 | 2459.62 |
| Serrano, Danny,24381 | 3970.52 | 0.00 | 0.00 | 2181.56 | 1788.96 |
| Jimenez, Erik, H,21989 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Goel, Dawn,23535 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cooper, Katherine, R,14314 | 122.95 | 0.00 | 0.00 | 0.00 | 122.95 |
| Raman, Abby, T,15122 | 5193.72 | 0.00 | 0.00 | 2071.42 | 3122.30 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Wu, Alisha,23654 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| Johnsen, Willie,15218 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Chander, Bethany, K,11446 | 8237.01 | 0.00 | 3399.99 | 2354.98 | 2482.04 |
| Sharma, Julie, R,18191 | 94.47 | 0.00 | 0.00 | 8.99 | 85.48 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Torres, Alfredo,27685 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Torres, Meghan, I,21256 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Rodriguez, Pamela,29065 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Pal, Mohamed, D,12698 | 6786.75 | 0.00 | 0.00 | 2071.42 | 4715.33 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
Generated 2025-12-21 22:31:09.604 UTC