[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 10 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Guo, Roger,13539 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Romero, Theodore,23747 | 1142.42 | 0.00 | 0.00 | 0.00 | 1142.42 |
| Taylor, Blake, S,17889 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Hall, Jenna,24015 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Raji, Marshall, L,27175 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Suri, Dominique,25584 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Browning, Casey,16449 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Navarro, Micheal,23625 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Zhang, Brent, L,18173 | 7189.35 | 0.00 | 0.00 | 2443.35 | 4746.00 |
| Liu, Jorge, J,20592 | 3113.22 | 0.00 | 782.99 | 0.00 | 2330.23 |
| Kapoor, Heidi, D,17937 | 3068.82 | 0.00 | 0.00 | 2443.35 | 625.47 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Romero, Roy, C,20859 | 2508.97 | 0.00 | 0.00 | 782.99 | 1725.98 |
| He, Clarence,16591 | 137.96 | 0.00 | 0.00 | 0.00 | 137.96 |
| Morgan, Lauren,24217 | 1209.47 | 0.00 | 0.00 | 0.00 | 1209.47 |
| Yuan, Katie,19459 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
Generated 2026-01-04 05:48:42.997 UTC