[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 77 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Tang, Alvin, L,21678 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Garcia, Kristopher, M,19070 | 4748.33 | 0.00 | 0.00 | 2443.35 | 2304.98 |
| Wright, Elijah, I,25577 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Saunders, Cynthia,24537 | 2511.32 | 0.00 | 0.00 | 0.00 | 2511.32 |
| Blanco, Pedro, C,26217 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Kelly, Marcus, A,25699 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Ms., Slattengren, Dianne, K.,27928 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Alonso, Tanya, K,26942 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Henderson, Faith,14545 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ray, Harold, A,13516 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Gomez, Larry, S,25778 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Ramos, Pedro, P,29416 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Washington, Anna,14817 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
Generated 2025-12-23 05:14:06.174 UTC