[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 52 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Arthur, Tammy, L,21363 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhou, Jaclyn, C,21179 | 4935.67 | 0.00 | 2443.35 | 0.00 | 2492.32 |
| Ortega, Linda, C,11756 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Alonso, Alfredo, T,23323 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Xie, Cristina, C,17050 | 4496.23 | 0.00 | 3578.27 | 0.00 | 917.96 |
| Raje, Jenny,20233 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Wang, Jon, A,26191 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Raman, Frederick, F,28942 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Xu, Roger,27968 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Powell, Kaitlyn,19598 | 5310.53 | 0.00 | 3578.27 | 0.00 | 1732.26 |
| Zheng, Aimee, H,24283 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Sun, Leah,17734 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Lu, Sandra, N,13521 | 4514.77 | 0.00 | 0.00 | 4514.77 | 0.00 |
| Ye, Claudia, J,19102 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Lopez, Kristi,28137 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Romero, Walter, A,25020 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Zhang, Tiffany, R,17318 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Shen, Dustin,27974 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Dominguez, Ebony, R,17350 | 127.47 | 0.00 | 0.00 | 0.00 | 127.47 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
Generated 2025-12-24 06:41:18.980 UTC