[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lin, Randy,14540 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Lopez, Marie,16192 | 101.45 | 0.00 | 0.00 | 29.48 | 71.97 |
| Henderson, Hunter, C,14812 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Rowe, Kristi, R,28692 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Suarez, Clinton,22657 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Richardson, Julia, N,27331 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Munoz, Danny,19355 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Wu, Jenny, S,23944 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Andersen, Dale, B,14992 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Jai, Christine, J,14814 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Ortega, Beth, A,12277 | 5666.52 | 0.00 | 0.00 | 2071.42 | 3595.10 |
| Suurs, Paul, J,15669 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Xu, Jorge, A,14955 | 103.97 | 0.00 | 0.00 | 0.00 | 103.97 |
| Moreno, Jamie,22526 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Blanco, Beth,29444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Ramos, Janet, B,20596 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Martin, Shannon, W,24045 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Garcia, Kristopher, M,19070 | 4748.33 | 0.00 | 0.00 | 2443.35 | 2304.98 |
| Martinez, Tabitha,26865 | 123.99 | 0.00 | 0.00 | 0.00 | 123.99 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 0.00 | 163.94 |
| Navarro, Erika, K,11476 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Ms., Sims, Anne, R.,26869 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ramos, Felicia,11557 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Blue, Oscar, L,27008 | 616.95 | 0.00 | 0.00 | 0.00 | 616.95 |
| Luo, Leonard, A,25582 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Ms., Smith, Samantha,29407 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Wu, Jeffery, D,25757 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Mehta, Kristina, R,20165 | 3191.42 | 0.00 | 699.10 | 0.00 | 2492.32 |
| Zhou, Curtis,25505 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Lu, Clayton, L,23613 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Suri, Carla,25547 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Romero, Armando, A,12596 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Moreno, Theodore, C,20872 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Zhang, Brent, L,18173 | 7189.35 | 0.00 | 0.00 | 2443.35 | 4746.00 |
| Rana, Geoffrey,28745 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Fernandez, Bruce, E,26888 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Munoz, Meghan, P,27810 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Jai, Terrence,27956 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Rana, Allen, D,19036 | 4763.34 | 0.00 | 0.00 | 2443.35 | 2319.99 |
| Rogers, Bryan,26890 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Thompson, Nathan, T,25523 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Liu, Willie,20561 | 3139.09 | 0.00 | 699.10 | 0.00 | 2439.99 |
| Washington, Destiny,22812 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Ma, Randy, R,24550 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Pal, Cedric,23235 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Henderson, Anna,24857 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Luo, Chad, R,21040 | 2566.95 | 0.00 | 0.00 | 2566.95 | 0.00 |
| Foster, Jordan, M,20807 | 3249.31 | 0.00 | 0.00 | 782.99 | 2466.32 |
| Mehta, Ronald, F,17649 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Baker, Katherine,19334 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Townsend, Roberto,19359 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Torres, Randall,25646 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Ruiz, Theodore,20052 | 3214.03 | 0.00 | 699.10 | 0.00 | 2514.93 |
| Butler, Adam,27925 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Garcia, Francisco,25701 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Srini, Molly, L,27790 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
Generated 2025-12-22 02:10:04.564 UTC