[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 1875 > < TAKE 125 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alvarez, Mallory, L,21124 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Williams, Jennifer, E,19457 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Ye, Micah, A,20952 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Nara, Terry,27305 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Kim, Carmen,25502 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Roberts, Mackenzie,23599 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Cooper, Steven,16435 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Vance, Martin, A,25604 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Barnes, Vanessa,13810 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Lal, Tony,28515 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Zeng, Kelvin, A,26207 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Zhao, Omar,27927 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Anand, Alejandro, R,28899 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Tang, Brad,25489 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| _SUM | 3388349.72 | 136130.99 | 556692.84 | 928131.45 | 1767394.44 |
Generated 2025-11-06 23:15:19.676 UTC