[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1171 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wang, Alvin,19939 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Wang, Tamara, L,17881 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Blanco, Mathew, B,12595 | 40.27 | 0.00 | 0.00 | 0.00 | 40.27 |
| Lewis, Katherine,14816 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| She, Clayton,13785 | 121.83 | 0.00 | 0.00 | 0.00 | 121.83 |
| Kapoor, Heidi, D,17937 | 3068.82 | 0.00 | 0.00 | 2443.35 | 625.47 |
| Zhao, Rafael,13412 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Raje, Kelsey, W,12227 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Romero, Tabitha, M,22416 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Hernandez, Kristi, L,22635 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Carlson, Jamie,23770 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yang, Ramon, K,13609 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Rowe, Kristi, R,28692 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Zhu, Autumn,14840 | 157.96 | 0.00 | 0.00 | 0.00 | 157.96 |
| Navarro, Robin, J,28696 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
Generated 2025-12-22 05:04:12.193 UTC