[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1063 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Dominguez, Alfredo, F,28443 | 3374.99 | 0.00 | 3374.99 | 0.00 | 0.00 |
| Cook, Trinity,14732 | 2450.08 | 0.00 | 699.10 | 0.00 | 1750.98 |
| Madan, Marie,27769 | 776.33 | 0.00 | 0.00 | 0.00 | 776.33 |
| Henderson, Jose,16716 | 27.92 | 0.00 | 0.00 | 0.00 | 27.92 |
| James, Katherine,28178 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Travers, Savannah,28363 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Jai, Clarence, S,18010 | 2485.07 | 0.00 | 699.10 | 0.00 | 1785.97 |
| Bennett, Katherine, S,15315 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Li, Tiffany, J,11224 | 6685.59 | 0.00 | 3578.27 | 2329.98 | 777.34 |
| Lu, Colleen,12714 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Garcia, Brett,14162 | 6473.70 | 0.00 | 3578.27 | 0.00 | 2895.43 |
| Perry, Aidan, O,12084 | 5985.21 | 0.00 | 3578.27 | 0.00 | 2406.94 |
| Perry, Jessica,28161 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Moyer, Jared, V,28198 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Gill, Deanna,13336 | 106.96 | 0.00 | 0.00 | 0.00 | 106.96 |
| Tang, Jon, K,14440 | 3367.38 | 0.00 | 0.00 | 1000.44 | 2366.94 |
| Thompson, Nicholas, D,11252 | 6685.56 | 0.00 | 3578.27 | 2341.97 | 765.32 |
| Brown, Jessica, L,11671 | 5970.23 | 0.00 | 3578.27 | 0.00 | 2391.96 |
| Gill, Micheal,25593 | 1264.84 | 0.00 | 0.00 | 0.00 | 1264.84 |
| Torres, Jasmine, A,11216 | 5948.24 | 0.00 | 3578.27 | 2369.97 | 0.00 |
| Bryant, Justin,29335 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Parker, Jenna, A,25990 | 5847.04 | 0.00 | 3399.99 | 0.00 | 2447.05 |
| Garcia, Ebony, S,14163 | 6567.02 | 0.00 | 3578.27 | 0.00 | 2988.75 |
| Moore, Alexis,28646 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Bryant, Jasmine, J,20463 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Cook, Erin,29280 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Hu, Brittney,14160 | 6679.70 | 0.00 | 3578.27 | 0.00 | 3101.43 |
| Edwards, Isaiah, B,29354 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Alvarez, Robyn, M,12255 | 2304.98 | 0.00 | 0.00 | 0.00 | 2304.98 |
| Bryant, Sydney, S,11412 | 9879.96 | 0.00 | 3374.99 | 0.00 | 6504.97 |
| Wu, Colin, T,15920 | 6247.52 | 0.00 | 0.00 | 2181.56 | 4065.96 |
| Flores, Kayla, O,28574 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Hernandez, Bailey, J,28626 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Blanco, Lawrence, W,11189 | 5944.22 | 0.00 | 3578.27 | 2365.95 | 0.00 |
| Chandra, Heidi, H,25993 | 4648.31 | 0.00 | 3374.99 | 0.00 | 1273.32 |
| Young, Timothy,28173 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Hughes, Fernando,20120 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Yuan, Nina, R,11531 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Rai, Jenny, D,11275 | 5955.23 | 0.00 | 3578.27 | 2376.96 | 0.00 |
| Romero, Jésus, R,16326 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Scott, Jenna, M,14740 | 1533.56 | 0.00 | 699.10 | 0.00 | 834.46 |
| Yang, Elijah, L,14744 | 1505.86 | 0.00 | 699.10 | 0.00 | 806.76 |
| Sai, Nancy, B,23440 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Russell, Victoria, D,11317 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Perry, Aaron,13195 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Coleman, Julia,11303 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Gao, Crystal, J,14795 | 4380.04 | 0.00 | 3578.27 | 0.00 | 801.77 |
| Patterson, Spencer, W,16925 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Scott, Aaron, C,16751 | 2492.32 | 0.00 | 0.00 | 0.00 | 2492.32 |
| Morris, Gabriella, F,13174 | 4558.52 | 0.00 | 2181.56 | 0.00 | 2376.96 |
| Sun, Cedric,17985 | 6016.66 | 0.00 | 0.00 | 2443.35 | 3573.31 |
| Serrano, Erik,26976 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Murphy, Mariah, J,28652 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Subram, Abby,13256 | 7494.88 | 0.00 | 0.00 | 2071.42 | 5423.46 |
| Ross, Oscar, V,20702 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Sanchez, Melissa,11880 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Garcia, Ethan,14738 | 1503.58 | 0.00 | 699.10 | 0.00 | 804.48 |
| Washington, Joan,11528 | 5959.71 | 0.00 | 3578.27 | 0.00 | 2381.44 |
| Martin, Ian, K,14709 | 4397.75 | 0.00 | 3578.27 | 0.00 | 819.48 |
| McDonald, Seth,24265 | 96.07 | 0.00 | 0.00 | 0.00 | 96.07 |
| Rivera, Richard, L,25998 | 4649.83 | 0.00 | 3399.99 | 0.00 | 1249.84 |
| Clark, Elizabeth, J,26005 | 4623.83 | 0.00 | 3399.99 | 0.00 | 1223.84 |
Generated 2025-12-23 11:52:34.288 UTC