[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Carlson, Gloria, P,15632 | 5245.06 | 0.00 | 3578.27 | 0.00 | 1666.79 |
| Ruiz, Audrey,12645 | 6847.76 | 0.00 | 0.00 | 2071.42 | 4776.34 |
| Lopez, Harold,26913 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Prasad, Regina, A,24192 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ma, Leah, H,14553 | 147.95 | 0.00 | 0.00 | 0.00 | 147.95 |
| Xu, Michele, K,15353 | 325.83 | 0.00 | 0.00 | 0.00 | 325.83 |
| King, Thomas, M,29433 | 1289.33 | 0.00 | 0.00 | 0.00 | 1289.33 |
| Mr., Saravan, K.,14974 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Roberts, Mackenzie,23599 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Liang, Jeffery,15711 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Liang, Krystal, S,12404 | 5251.71 | 0.00 | 0.00 | 2071.42 | 3180.29 |
| Fernandez, Stanley, R,24064 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Reed, Jesse, E,22429 | 1777.95 | 0.00 | 0.00 | 0.00 | 1777.95 |
| Deng, Brendan,25726 | 663.44 | 0.00 | 0.00 | 0.00 | 663.44 |
| Dominguez, Felicia, R,14196 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Garcia, Emmanuel, T,12263 | 6829.38 | 0.00 | 0.00 | 2071.42 | 4757.96 |
| Allen, Jada,26866 | 615.46 | 0.00 | 0.00 | 0.00 | 615.46 |
| Hernandez, Anne, B,11240 | 7586.23 | 0.00 | 3399.99 | 2369.96 | 1816.28 |
| Lu, Mandy,14988 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Zeng, Valerie,17977 | 2966.03 | 0.00 | 0.00 | 2181.56 | 784.47 |
| Lin, Randy,14540 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Alvarez, Casey, A,28557 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Ye, Kristen, D,12486 | 5652.40 | 0.00 | 0.00 | 2049.10 | 3603.30 |
| Shen, Damien, C,14964 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Ortega, Nelson,15118 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Rubio, Jerome, L,14792 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Garcia, Tabitha,27778 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Smith, Tabitha,14787 | 163.45 | 0.00 | 0.00 | 0.00 | 163.45 |
| Andersen, Bethany,25324 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Julie, H,12214 | 6803.92 | 0.00 | 0.00 | 2049.10 | 4754.82 |
Generated 2025-12-23 09:11:14.753 UTC