[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 248 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rubio, Desiree, D,21189 | 4208.31 | 0.00 | 2443.35 | 0.00 | 1764.96 |
| Torres, Theresa,21202 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Arun, Nancy, C,21169 | 4647.88 | 0.00 | 2181.56 | 0.00 | 2466.32 |
| Xu, Jaclyn, L,12685 | 6904.11 | 0.00 | 2049.10 | 0.00 | 4855.01 |
| Goel, Bridget,26134 | 1926.45 | 0.00 | 782.99 | 0.00 | 1143.46 |
| Blanco, Micheal, A,11113 | 109.88 | 0.00 | 0.00 | 49.97 | 59.91 |
| Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 2181.56 | 0.00 | 563.77 |
| Sanz, Walter, J,18195 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Arun, Candace, J,21393 | 4925.17 | 0.00 | 2443.35 | 0.00 | 2481.82 |
| Serrano, Alfredo,21258 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Liu, Cedric,12677 | 6785.47 | 0.00 | 2071.42 | 0.00 | 4714.05 |
| Sun, Jamie,21389 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Jai, Michele, E,21225 | 4732.86 | 0.00 | 0.00 | 2181.56 | 2551.30 |
| Gutierrez, Jill, N,26024 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Hall, Jesse,26133 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Li, Luis, K,20251 | 59.47 | 0.00 | 0.00 | 0.00 | 59.47 |
| Ms., Roy, Lisa, K.,21403 | 4895.69 | 0.00 | 0.00 | 2443.35 | 2452.34 |
| Chapman, Alicia, A,21418 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Madan, Bruce, G,18206 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Luo, Johnny,21359 | 3032.31 | 0.00 | 0.00 | 2443.35 | 588.96 |
| Sanz, Francis,12577 | 2614.08 | 0.00 | 0.00 | 2049.10 | 564.98 |
| Sanchez, Lydia, S,12579 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Chander, Devon,24612 | 2152.20 | 0.00 | 0.00 | 1000.44 | 1151.76 |
| Lopez, Kristopher, L,21560 | 4702.39 | 0.00 | 0.00 | 2181.56 | 2520.83 |
| King, Kevin, W,21402 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Coleman, Nicole, A,21558 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Jai, Latoya, S,21229 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Fernandez, Kristina, A,12581 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Zhou, Trisha, B,12686 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Ortega, Tyrone, H,12583 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Zhang, Aimee,26025 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
Generated 2025-12-24 06:20:57.007 UTC