[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 14 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martinez, Andre,16588 | 6994.58 | 0.00 | 0.00 | 2181.56 | 4813.02 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rai, Donna,12235 | 62.76 | 0.00 | 0.00 | 0.00 | 62.76 |
| McDonald, Deborah, R,16275 | 3282.83 | 0.00 | 2443.35 | 0.00 | 839.48 |
| Lin, Brent, L,27788 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Torres, Randall,25646 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Torres, Audrey,16571 | 52.92 | 0.00 | 0.00 | 0.00 | 52.92 |
| Garcia, Bob,19186 | 1562.41 | 0.00 | 1000.44 | 0.00 | 561.97 |
| Torres, Janet, J,23985 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lu, Erica,27009 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Raji, Raul, P,21135 | 103.95 | 0.00 | 0.00 | 0.00 | 103.95 |
| Wu, Cedric, E,21025 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Martinez, Donald, D,25482 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Rubio, Teresa, R,27121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Washington, Julia, R,20875 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Ruiz, Stacy,16823 | 7242.35 | 0.00 | 0.00 | 2443.35 | 4799.00 |
| Subram, Levi,15619 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Nara, Terry,27305 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Martin, Shannon, W,24045 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Fernandez, Harold, C,29359 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Rivera, Garrett,22642 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Parker, Haley,14694 | 156.94 | 0.00 | 0.00 | 0.00 | 156.94 |
| Muñoz, Dana,28459 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Prasad, Sergio, J,19290 | 1605.40 | 0.00 | 0.00 | 1000.44 | 604.96 |
| Ortega, Leslie,24851 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Cooper, Mariah, J,27901 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Fernandez, Bruce, E,26888 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
Generated 2025-12-23 11:48:15.809 UTC