[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1059 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mr., Thompson, Austin,12513 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Sr., Cai, Ramón, S,16599 | 149.46 | 0.00 | 0.00 | 0.00 | 149.46 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Ramos, Tabitha,20147 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Blanco, Jaime,22528 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jackson, Alexandra, A,24184 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hill, Gabriella,26364 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Morgan, Angel, G,24835 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Butler, Adam,27925 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raji, Jenny,21870 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Lopez, Samuel, L,26858 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Perez, Dominic, A,23940 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Rogers, Bryan,26890 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Patel, Rebekah, R,22396 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Chande, Lacey, A,24555 | 58.95 | 0.00 | 0.00 | 0.00 | 58.95 |
| Zeng, Alan, M,22321 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Fernandez, Deanna,24554 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zhou, Leah, L,22309 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Rivera, Katelyn,23948 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Diaz, Mariah,25465 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Yang, Marshall, E,12564 | 110.75 | 0.00 | 0.00 | 0.00 | 110.75 |
| Suri, Dominique,25584 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Luo, Gregory,17642 | 32.95 | 0.00 | 0.00 | 0.00 | 32.95 |
| Garcia, Arthur, T,29413 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Chande, Tamara, L,28693 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Gutierrez, Marie, F,29431 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
Generated 2025-12-23 11:52:24.335 UTC