[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1218 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ortega, Walter,28377 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Andersen, April, C,20973 | 193.98 | 0.00 | 0.00 | 0.00 | 193.98 |
| Fernandez, Stanley, R,24064 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Henderson, Alexandria, R,11555 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Madan, Harold, A,23938 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Martinez, Tabitha,26865 | 123.99 | 0.00 | 0.00 | 0.00 | 123.99 |
| Pal, Mohamed,20550 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sai, Marie, A,24582 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Martinez, Carla,24852 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Rai, Alicia, M,28914 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Cai, Jenny, W,29387 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Carlson, Diane, W,21074 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Subram, Bobby, J,29373 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Jimenez, Roy,12334 | 44.22 | 0.00 | 0.00 | 0.00 | 44.22 |
| Yang, Jessie, E,20053 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Guo, Wesley,16470 | 3021.04 | 0.00 | 0.00 | 2181.56 | 839.48 |
| Sanz, Latasha,29384 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ruiz, Ruben, A,20055 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Suarez, Ross, C,27940 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhao, Sandra, S,22503 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Gill, Briana, D,12654 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Gutierrez, Casey,12519 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Suarez, Felicia, W,28703 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Ms., Sims, Anne, R.,26869 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Rowe, Alberto, W,26973 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Suarez, Larry, D,28694 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Carlson, Darren, D,29478 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Rodriguez, Marie, L,17960 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Raje, Jerry, E,21848 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Srini, Francisco, H,12602 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
Generated 2025-12-24 06:16:20.286 UTC