[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Robinson, Brandon, J,15661 | 5208.04 | 0.00 | 3578.27 | 0.00 | 1629.77 |
| Blanco, Max,26360 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Torres, Katelyn, L,20804 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Torres, Cheryl, T,25727 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Hernandez, Renee, C,17803 | 2761.02 | 0.00 | 0.00 | 2181.56 | 579.46 |
| Jai, Kate,14706 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sai, Gerald, L,27894 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Rodriguez, Janelle,26887 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Fernandez, Dominique,12839 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Rogers, Bryan,26890 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Young, Henry,12403 | 67.27 | 0.00 | 0.00 | 0.00 | 67.27 |
| Luo, Karla, V,11574 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Miller, Olivia, H,26860 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lal, Tony,28515 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Kumar, Roger, C,15922 | 148.20 | 0.00 | 0.00 | 0.00 | 148.20 |
Generated 2025-12-21 20:26:47.141 UTC