[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 29 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanchez, Michelle, R,26569 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Becker, Gregory, M,13104 | 6894.44 | 0.00 | 0.00 | 2071.42 | 4823.02 |
| Sanchez, Henry,26968 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Huang, Lisa, L,14102 | 3667.23 | 0.00 | 0.00 | 2071.42 | 1595.81 |
| Lu, Ronnie,19950 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Vazquez, Juan, P,22578 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Chen, Tiffany, A,23348 | 4167.31 | 0.00 | 0.00 | 2443.35 | 1723.96 |
| Martinez, Fernando,20454 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Vazquez, Krista,26164 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Romero, Walter, A,25020 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Raji, Willie, T,11070 | 8165.55 | 0.00 | 3399.99 | 2345.22 | 2420.34 |
| Ms., Simon, Britta,25946 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Dominguez, Wendy,11035 | 6451.31 | 3374.99 | 0.00 | 0.00 | 3076.32 |
| Deng, Deborah,23324 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Ruiz, Krista, C,13081 | 6772.15 | 0.00 | 0.00 | 2049.10 | 4723.05 |
| Muñoz, Ruben, L,11451 | 8249.49 | 0.00 | 3399.99 | 2366.94 | 2482.56 |
| Griffin, Noah, E,29118 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Blanco, Cheryl,13524 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Ms., Roy, Lisa, K.,21403 | 4895.69 | 0.00 | 0.00 | 2443.35 | 2452.34 |
| Mehta, Pamela,22005 | 135.46 | 0.00 | 0.00 | 0.00 | 135.46 |
| Johnsen, Eddie,28935 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Gutierrez, Hector,26423 | 2001.97 | 0.00 | 0.00 | 782.99 | 1218.98 |
| Patel, Toni, E,25829 | 1894.07 | 0.00 | 699.10 | 0.00 | 1194.97 |
Generated 2025-12-22 01:22:18.139 UTC