[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1156 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xie, Grant, D,17770 | 2715.41 | 0.00 | 0.00 | 1000.44 | 1714.97 |
| Xie, Jerry,20081 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Romero, Audrey, S,22387 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Watson, Isaac, S,15188 | 1631.46 | 0.00 | 782.99 | 0.00 | 848.47 |
| Kelly, Patrick,16144 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Perez, Sean,27105 | 4447.15 | 0.00 | 0.00 | 2049.10 | 2398.05 |
| Young, Eduardo, C,24800 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Howard, Trinity, A,27440 | 4447.15 | 0.00 | 0.00 | 2049.10 | 2398.05 |
| Peterson, Andrea,19769 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Serrano, Rodney, L,14979 | 4183.23 | 0.00 | 3578.27 | 0.00 | 604.96 |
| Jones, Robert,21900 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Thompson, Jessica,14592 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rowe, Casey, T,20967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yang, Suzanne,18628 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Yuan, Karl, L,12835 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Patterson, Adam, M,19696 | 597.26 | 0.00 | 0.00 | 0.00 | 597.26 |
| Bryant, Taylor, D,15901 | 1376.97 | 0.00 | 0.00 | 782.99 | 593.98 |
| Sai, Douglas, A,20833 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Suarez, Marvin, M,22443 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| He, Vincent, M,14138 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Garcia, Adriana,23500 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Lewis, Daniel, W,18365 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thompson, Anthony,13850 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Washington, James, R,24127 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Harris, Jose, A,28609 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Phillips, Alex, F,24508 | 121.57 | 0.00 | 0.00 | 0.00 | 121.57 |
| Perez, Thomas,17466 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Chande, Leonard, L,18184 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Gonzalez, Douglas, E,20174 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Taylor, Samuel, A,16872 | 2359.24 | 0.00 | 0.00 | 0.00 | 2359.24 |
| Ramirez, Chloe,26520 | 2827.72 | 0.00 | 0.00 | 2049.10 | 778.62 |
| Martin, Cheryl, C,16448 | 6906.89 | 0.00 | 0.00 | 2181.56 | 4725.33 |
| Bradley, Alyssa, C,15677 | 7200.86 | 0.00 | 0.00 | 2443.35 | 4757.51 |
| Davis, Alexandra,12047 | 43.99 | 0.00 | 0.00 | 0.00 | 43.99 |
| Raje, Shawna, F,19046 | 3320.43 | 0.00 | 0.00 | 1000.44 | 2319.99 |
| Raman, Gerald, V,22691 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Sanchez, Destiny, J,27600 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Powell, Chloe, J,26065 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Foster, Jack,20008 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Reed, Devin, J,14395 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Bennett, Jacqueline,11199 | 131.75 | 0.00 | 0.00 | 0.00 | 131.75 |
| Alonso, Neil, M,13332 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Smith, Kari, A,14164 | 6484.71 | 0.00 | 3578.27 | 0.00 | 2906.44 |
| Powell, Miguel,22240 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Torres, Allison, E,21244 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Wright, Thomas, M,14044 | 3357.72 | 0.00 | 0.00 | 1000.44 | 2357.28 |
| Griffin, Gail,13436 | 4498.53 | 0.00 | 0.00 | 2181.56 | 2316.97 |
| Wilson, Olivia, L,29044 | 4320.62 | 0.00 | 3578.27 | 0.00 | 742.35 |
| Ross, Gavin,16114 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Ashe, Reginald,28706 | 773.63 | 0.00 | 0.00 | 0.00 | 773.63 |
| Ye, Trisha, R,27166 | 827.33 | 0.00 | 0.00 | 0.00 | 827.33 |
| Madan, Deanna, C,27768 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Sanchez, Cody,24794 | 2448.04 | 0.00 | 0.00 | 0.00 | 2448.04 |
| Gomez, Frank,18011 | 2590.36 | 0.00 | 699.10 | 0.00 | 1891.26 |
| Yuan, Terrence, T,15463 | 2802.49 | 0.00 | 0.00 | 2181.56 | 620.93 |
| Hughes, Paige,17980 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 |
| Price, Sarah, C,11186 | 41.28 | 0.00 | 0.00 | 0.00 | 41.28 |
| Cox, Danielle,11207 | 77.27 | 0.00 | 0.00 | 74.98 | 2.29 |
| Martinez, Anthony,26376 | 121.93 | 0.00 | 0.00 | 0.00 | 121.93 |
| Gonzales, Marcus, M,25334 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Robinson, Devin,17664 | 624.95 | 0.00 | 0.00 | 0.00 | 624.95 |
| Xie, Bonnie,14775 | 8404.28 | 0.00 | 3578.27 | 2419.06 | 2406.95 |
Generated 2025-12-23 12:13:06.649 UTC