[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1031 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Arun, Roy, W,23620 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Diaz, Krista,28913 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| James, Arianna, A,25799 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Cox, Melanie, C,12496 | 204.58 | 0.00 | 0.00 | 0.00 | 204.58 |
| Goel, Louis,24055 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Gonzales, Emma, P,15681 | 105.56 | 0.00 | 0.00 | 33.98 | 71.58 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Nath, Clarence,24050 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Rana, Geoffrey,28745 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Black, Nina, L,17968 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Hernandez, Gerald, L,24054 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Moreno, Kari, S,15052 | 44.57 | 0.00 | 0.00 | 0.00 | 44.57 |
| Blanco, Meghan,17961 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Deng, Sharon, A,26893 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gomez, Joe, E,16574 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Lal, Ricardo, C,17958 | 2811.52 | 0.00 | 0.00 | 2181.56 | 629.96 |
| Gutierrez, Teresa, A,15083 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Smith, Destiny,22428 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Chander, Nichole, H,28451 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Robinson, Brandon, J,15661 | 5208.04 | 0.00 | 3578.27 | 0.00 | 1629.77 |
| Romero, Armando, A,12596 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Sai, Roy, J,16038 | 84.25 | 0.00 | 0.00 | 0.00 | 84.25 |
| Romero, Sheila,20577 | 3080.27 | 0.00 | 782.99 | 0.00 | 2297.28 |
| Sun, Rosa,26900 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Luo, Sharon, D,11553 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Raji, Karla, V,15929 | 6944.58 | 0.00 | 2181.56 | 0.00 | 4763.02 |
| Nara, Jaime, D,13262 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Jimenez, Rodney, R,12476 | 73.77 | 0.00 | 0.00 | 0.00 | 73.77 |
| Shen, Casey, D,12503 | 84.46 | 0.00 | 0.00 | 0.00 | 84.46 |
Generated 2025-12-22 02:34:03.190 UTC