[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 969 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Sandoval, Jill,14143 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Rodriguez, Jay, M,28411 | 134.95 | 0.00 | 0.00 | 134.95 | 0.00 |
| Suri, Terrance, C,21046 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Sai, Kaitlin, J,14529 | 254.06 | 0.00 | 0.00 | 0.00 | 254.06 |
| Sanz, Naomi,12840 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Rana, Kristopher, W,22550 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Subram, Allen,17895 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Chander, Peter, L,14836 | 115.25 | 0.00 | 0.00 | 78.98 | 36.27 |
| Alvarez, Cheryl, A,12320 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Sharma, Nina,23760 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Torres, Lawrence,15671 | 31.55 | 0.00 | 0.00 | 7.28 | 24.27 |
| Martin, Paula, B,21855 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Morgan, Sean,14993 | 152.94 | 0.00 | 0.00 | 74.98 | 77.96 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
Generated 2024-11-10 16:47:42.988 UTC