[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Morris, Jeremiah,27416 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Reed, Anna, S,27271 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Blanco, Tyrone, F,19458 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Nath, Jenny,27281 | 4540.47 | 0.00 | 0.00 | 2071.42 | 2469.05 |
| Luo, Jenny, L,19474 | 1589.75 | 0.00 | 0.00 | 782.99 | 806.76 |
| Lopez, Ruth, D,17902 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Wright, Chloe,14420 | 3320.43 | 0.00 | 0.00 | 1000.44 | 2319.99 |
| Jenkins, Brianna, P,27455 | 4532.97 | 0.00 | 0.00 | 2071.42 | 2461.55 |
| Barnes, Abigail,15903 | 1372.95 | 0.00 | 0.00 | 782.99 | 589.96 |
| Munoz, Janet,11439 | 12489.17 | 0.00 | 0.00 | 6947.81 | 5541.36 |
| Murphy, Sean,15969 | 3109.95 | 0.00 | 0.00 | 782.99 | 2326.96 |
| Campbell, Savannah,15989 | 3140.92 | 0.00 | 0.00 | 782.99 | 2357.93 |
| Diaz, Cameron,14494 | 1769.93 | 0.00 | 0.00 | 1000.44 | 769.49 |
| Shan, Maurice, M,11433 | 12909.67 | 0.00 | 0.00 | 6934.48 | 5975.19 |
| Hall, Samantha,14484 | 3345.40 | 0.00 | 0.00 | 1000.44 | 2344.96 |
| Cook, Ian, K,27535 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Bryant, Amanda, A,27537 | 4469.47 | 0.00 | 0.00 | 2071.42 | 2398.05 |
| Lal, Hunter,27573 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Carlson, Teresa, L,12852 | 4411.37 | 0.00 | 0.00 | 2049.10 | 2362.27 |
| Cox, Steven, E,15964 | 3117.96 | 0.00 | 0.00 | 782.99 | 2334.97 |
| Hill, Hunter,14001 | 106.96 | 0.00 | 0.00 | 0.00 | 106.96 |
| Taylor, Cameron, T,12445 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Simpson, Mindy, A,15200 | 3142.97 | 0.00 | 0.00 | 782.99 | 2359.98 |
| Sr., Alonso, Jésus, V,20841 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Yuan, Mindy, D,12201 | 58.18 | 0.00 | 0.00 | 0.00 | 58.18 |
| Carter, Thomas, W,22792 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gao, Heather,19061 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Zhang, Caleb,12863 | 4478.35 | 0.00 | 0.00 | 2071.42 | 2406.93 |
| Carter, Isaiah,27572 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Carter, Gabrielle, B,16596 | 4486.54 | 0.00 | 0.00 | 2181.56 | 2304.98 |
| Patel, Kristopher,15976 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Ortega, Alberto,17950 | 2732.70 | 0.00 | 0.00 | 1000.44 | 1732.26 |
| Subram, Abby,13256 | 7494.88 | 0.00 | 0.00 | 2071.42 | 5423.46 |
| Morgan, Gabrielle,15980 | 3077.98 | 0.00 | 0.00 | 782.99 | 2294.99 |
| Sanchez, Tina,27527 | 4514.97 | 0.00 | 0.00 | 2071.42 | 2443.55 |
| Zhu, Micah, V,11576 | 4486.41 | 0.00 | 0.00 | 2071.42 | 2414.99 |
| Price, Elizabeth, J,14464 | 3357.72 | 0.00 | 0.00 | 1000.44 | 2357.28 |
| Powell, Robert, C,27468 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Watson, Jennifer, H,15965 | 3108.95 | 0.00 | 0.00 | 782.99 | 2325.96 |
| Gonzalez, Edward,15968 | 3099.96 | 0.00 | 0.00 | 782.99 | 2316.97 |
| Hill, Madeline, D,27574 | 4456.14 | 0.00 | 0.00 | 2049.10 | 2407.04 |
| Robinson, Jeremy, S,14470 | 3382.40 | 0.00 | 0.00 | 1000.44 | 2381.96 |
| Butler, Jacqueline, L,27540 | 4504.46 | 0.00 | 0.00 | 2071.42 | 2433.04 |
| Diaz, Nathan,14495 | 1839.92 | 0.00 | 0.00 | 1000.44 | 839.48 |
| Thomas, Brianna,15302 | 3134.95 | 0.00 | 0.00 | 782.99 | 2351.96 |
| Richardson, Alexandra,12761 | 5929.23 | 0.00 | 3578.27 | 0.00 | 2350.96 |
| Lu, Alvin,15417 | 3120.26 | 0.00 | 0.00 | 782.99 | 2337.27 |
| Taylor, Samantha, K,12773 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Richardson, Jesse, M,25895 | 4649.83 | 0.00 | 3399.99 | 0.00 | 1249.84 |
| Alexander, James,26110 | 5759.06 | 0.00 | 3374.99 | 0.00 | 2384.07 |
| Cook, Mason, M,17614 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Griffin, Fernando, J,23027 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ferrier, Gregory, J,18822 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Andersen, Barbara, G,17984 | 6083.17 | 0.00 | 0.00 | 2443.35 | 3639.82 |
| Carlson, Daisy, B,17976 | 5801.38 | 0.00 | 0.00 | 3446.40 | 2354.98 |
| Gonzalez, Chloe,14461 | 3310.41 | 0.00 | 0.00 | 1000.44 | 2309.97 |
| Rodriguez, Emily, R,27559 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Beck, Brendan,17952 | 3941.53 | 0.00 | 0.00 | 2181.56 | 1759.97 |
| Goel, Sheena,12833 | 4359.07 | 0.00 | 0.00 | 2049.10 | 2309.97 |
| Carlson, Walter,19943 | 3112.97 | 0.00 | 0.00 | 782.99 | 2329.98 |
| Johnson, Devin,15985 | 3179.95 | 0.00 | 0.00 | 782.99 | 2396.96 |
| Alexander, Isabelle, L,15992 | 3194.93 | 0.00 | 0.00 | 782.99 | 2411.94 |
Generated 2025-12-21 22:26:28.377 UTC