[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 < SKIP 156 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Blanco, Clinton, J,14195 | 8316.29 | 0.00 | 3578.27 | 0.00 | 4738.02 |
| Ross, Hailey, C,13612 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Chander, Kelli,26934 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Pal, Maurice,26929 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Rodriguez, Bruce,28473 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Alexander, Justin, M,12272 | 5139.73 | 0.00 | 0.00 | 2071.42 | 3068.31 |
| Ye, Dawn,25488 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Yuan, Bridget,26211 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Simmons, Wyatt, V,22604 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Pal, Corey,25774 | 2537.32 | 0.00 | 0.00 | 0.00 | 2537.32 |
| Kumar, Arturo, W,24044 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Gutierrez, Kathleen,17786 | 89.46 | 0.00 | 0.00 | 0.00 | 89.46 |
| _SUM | 3388349.72 | 33221.07 | 554871.66 | 778572.36 | 2021684.63 |
| Serrano, Erika,12394 | 5635.91 | 0.00 | 0.00 | 2049.10 | 3586.81 |
| Bryant, Ian,27319 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Hernandez, Naomi,25686 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ye, Kelli,19470 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Vance, Ebony,20724 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 0.00 | 3087.31 |
| Ma, Alisha,17972 | 2791.53 | 0.00 | 0.00 | 2181.56 | 609.97 |
| Lopez, Geoffrey, A,29451 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Howard, Victoria, L,21525 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Gill, Krista,12664 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Romero, Juan, A,16324 | 3282.81 | 0.00 | 0.00 | 2443.35 | 839.46 |
| Reed, Jesse, E,22429 | 1777.95 | 0.00 | 0.00 | 0.00 | 1777.95 |
| Thompson, Nathan, T,25523 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sun, Stacey, S,19361 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Sara, Toni, E,14146 | 6750.56 | 0.00 | 3578.27 | 827.33 | 2344.96 |
| Townsend, Michelle, P,12864 | 86.24 | 0.00 | 0.00 | 0.00 | 86.24 |
| Prasad, Rebekah, A,15919 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Gomez, Bruce,15695 | 8324.24 | 0.00 | 3578.27 | 0.00 | 4745.97 |
Generated 2026-01-04 05:48:27.246 UTC