[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 1750 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Arun, Candace, J,21393 | 4925.17 | 0.00 | 2443.35 | 0.00 | 2481.82 |
| He, Jorge,20268 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sun, Jamie,21389 | 2770.52 | 0.00 | 2181.56 | 0.00 | 588.96 |
| Simmons, Gabrielle,29183 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Jiménez, Orlando, M,21283 | 124.94 | 0.00 | 0.00 | 0.00 | 124.94 |
| Ms., Roy, Lisa, K.,21403 | 4895.69 | 0.00 | 2443.35 | 0.00 | 2452.34 |
| Chen, Autumn, I,21408 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 27.28 | 172.98 |
| Kumar, Kurt, L,27360 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 2071.42 | 0.00 | 4768.04 |
| Ma, Brittney,12584 | 2633.39 | 0.00 | 2071.42 | 0.00 | 561.97 |
| Ramos, Jerome, L,29187 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Sanchez, Lydia, S,12579 | 2589.09 | 0.00 | 2049.10 | 0.00 | 539.99 |
| Suarez, Brandi,21874 | 4638.89 | 0.00 | 2181.56 | 0.00 | 2457.33 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Travers, Jimmy, V,12674 | 6829.47 | 0.00 | 2071.42 | 0.00 | 4758.05 |
| Shan, Shawna, K,27869 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| Sanz, Julio, H,21404 | 4684.39 | 0.00 | 2181.56 | 0.00 | 2502.83 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 49.99 | 49.48 |
| Powell, Grace, B,29194 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Coleman, Nicole, A,21558 | 4919.30 | 0.00 | 2443.35 | 0.00 | 2475.95 |
| Ortega, Tyrone, H,12583 | 2646.40 | 0.00 | 2071.42 | 0.00 | 574.98 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Nara, Cedric, M,21875 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Gonzalez, Kaylee, L,21895 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Hernandez, Orlando, C,21951 | 4923.29 | 0.00 | 2443.35 | 0.00 | 2479.94 |
| Hernandez, Joan, J,21892 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Navarro, Stacy, C,12688 | 6867.44 | 0.00 | 2071.42 | 0.00 | 4796.02 |
| Sanchez, Candace, L,21567 | 4973.28 | 0.00 | 2443.35 | 0.00 | 2529.93 |
| Sanchez, Carla,18274 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
Generated 2025-11-06 19:00:40.435 UTC