[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1001 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Madan, Virginia,20966 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Shen, Edwin, C,16288 | 2768.53 | 0.00 | 0.00 | 2181.56 | 586.97 |
| Russell, Jack,29050 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Van, Carolyn,23126 | 45.22 | 0.00 | 0.00 | 0.00 | 45.22 |
| Thompson, Victoria, A,13857 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Rubio, Paula, A,13727 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Pal, Leonard, B,14960 | 2803.52 | 0.00 | 0.00 | 2181.56 | 621.96 |
| Dominguez, Mathew, G,16433 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Munoz, Joanna,13812 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Jones, Robert,21900 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Pal, Louis, M,19851 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Cooper, Cole, C,19707 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Henderson, Grace, M,11473 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Gonzales, Nicole, M,17737 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Patterson, Madison,17779 | 4250.21 | 0.00 | 0.00 | 1000.44 | 3249.77 |
| Andersen, Dustin, L,26684 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Robinson, Anna,25955 | 4643.83 | 0.00 | 3374.99 | 0.00 | 1268.84 |
| Rodriguez, Johnathan, A,17973 | 1852.26 | 0.00 | 0.00 | 0.00 | 1852.26 |
| Shen, Chad,18143 | 3063.06 | 0.00 | 699.10 | 0.00 | 2363.96 |
| Ruiz, Billy, M,26500 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Peterson, Maria, W,14239 | 3295.43 | 0.00 | 0.00 | 1000.44 | 2294.99 |
| Morris, Isaiah,29019 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 |
| Powell, Natalie, L,26607 | 2813.77 | 0.00 | 0.00 | 2071.42 | 742.35 |
| Roberts, Sara, D,26125 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Garcia, Adriana,23500 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Richardson, Alex, E,22160 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Mitchell, Julia,25789 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Martin, Destiny, C,25475 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sai, Darren, E,25457 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Richardson, Trinity,11263 | 6754.06 | 0.00 | 3578.27 | 2394.97 | 780.82 |
| Ross, Trevor, L,28071 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Yuan, Alisha, M,27013 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Davis, David,22159 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Patterson, Rachel, K,14413 | 1889.91 | 0.00 | 0.00 | 1000.44 | 889.47 |
| Martinez, Marcus, L,13484 | 4813.32 | 0.00 | 0.00 | 2443.35 | 2369.97 |
| Sanchez, Charles, W,14112 | 3361.39 | 0.00 | 0.00 | 1000.44 | 2360.95 |
| Ye, Rafael, V,14242 | 3351.40 | 0.00 | 0.00 | 1000.44 | 2350.96 |
| Zhu, Brittney, E,20111 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Pal, Gregory,19436 | 1942.70 | 0.00 | 0.00 | 782.99 | 1159.71 |
| Morris, Nathaniel, K,13928 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Zhu, Rafael,16228 | 569.97 | 0.00 | 0.00 | 0.00 | 569.97 |
| Thomas, Joshua, A,18643 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Butler, Alexia, F,23882 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Martinez, Eduardo, W,24234 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Washington, Alexandria, M,22241 | 1149.47 | 0.00 | 0.00 | 0.00 | 1149.47 |
| Sai, Kristina,26957 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Sharma, Aaron, J,11801 | 87.28 | 0.00 | 0.00 | 0.00 | 87.28 |
| Jai, Mitchell, D,13546 | 2339.97 | 0.00 | 0.00 | 0.00 | 2339.97 |
| Rana, Veronica, R,19453 | 4267.90 | 0.00 | 699.10 | 0.00 | 3568.80 |
| Cook, Dalton, E,18851 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Adams, Stephanie, R,14042 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Smith, Samantha, J,14479 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| McDonald, Cesar, C,12821 | 124.94 | 0.00 | 0.00 | 0.00 | 124.94 |
| Xie, Roger, V,22489 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Parker, Devin,11684 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Ramirez, Zoe, R,11710 | 97.98 | 0.00 | 0.00 | 0.00 | 97.98 |
| Ross, Brianna, L,12875 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Hu, Brittney,14160 | 6679.70 | 0.00 | 3578.27 | 0.00 | 3101.43 |
| Powell, Miguel,22240 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Hayes, Wyatt, M,17467 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| James, Nathaniel, C,11867 | 82.93 | 0.00 | 0.00 | 0.00 | 82.93 |
| Wright, Thomas, M,14044 | 3357.72 | 0.00 | 0.00 | 1000.44 | 2357.28 |
Generated 2025-12-24 06:23:32.425 UTC