[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 876 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alvarez, Theresa, H,12280 | 2344.96 | 0.00 | 0.00 | 0.00 | 2344.96 |
| Butler, Alyssa, L,23201 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Kawai, Masato,25663 | 94.97 | 0.00 | 0.00 | 0.00 | 94.97 |
| Arthur, Kaitlin,16438 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Lal, Tonya, B,24108 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Zeng, Clarence, L,12234 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Sanz, Erik, I,22464 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Bradley, Richard,29173 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Jackson, Jessica, M,27443 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Tang, Karla, M,14851 | 2802.49 | 0.00 | 0.00 | 2181.56 | 620.93 |
| Taylor, Nathan, L,26521 | 2821.72 | 0.00 | 0.00 | 2071.42 | 750.30 |
| Lal, Alejandro,12213 | 4419.06 | 0.00 | 0.00 | 2049.10 | 2369.96 |
| Subram, Regina, R,20720 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Bennett, Wyatt, J,13658 | 4787.61 | 0.00 | 0.00 | 2443.35 | 2344.26 |
| Davis, Victoria, J,13704 | 2736.53 | 0.00 | 0.00 | 2181.56 | 554.97 |
| Ross, Taylor, S,26545 | 2822.76 | 0.00 | 0.00 | 2071.42 | 751.34 |
| Ruiz, Renee, L,26499 | 2848.76 | 0.00 | 0.00 | 2071.42 | 777.34 |
| Wang, Alisha, V,18164 | 3330.42 | 0.00 | 0.00 | 1000.44 | 2329.98 |
| Ward, Faith, A,12226 | 4368.06 | 0.00 | 0.00 | 2049.10 | 2318.96 |
| Torres, Brianna, M,14116 | 3317.41 | 0.00 | 0.00 | 1000.44 | 2316.97 |
| Morgan, Riley, R,26530 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Hayes, Hunter,26579 | 2840.42 | 0.00 | 0.00 | 2049.10 | 791.32 |
| Gill, Raquel, T,17217 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Chen, Eric, N,15493 | 3099.96 | 0.00 | 0.00 | 782.99 | 2316.97 |
| Lin, Martha,20678 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Ross, Caroline,17573 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Watson, Brianna,28812 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Adams, Aaron, B,28866 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Martin, Blake,21782 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Blue, Paige,20326 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Ms., Smith-Bates, Lorrin, G.,17641 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Rogers, Juan, R,14926 | 3058.31 | 0.00 | 0.00 | 2443.35 | 614.96 |
| Chandra, Shane, M,19287 | 2508.97 | 0.00 | 0.00 | 782.99 | 1725.98 |
| Madan, Brett, L,28727 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Hughes, Taylor, J,14285 | 1804.92 | 0.00 | 0.00 | 1000.44 | 804.48 |
| Perry, Emily, F,26649 | 4433.17 | 0.00 | 0.00 | 2049.10 | 2384.07 |
| Barnes, Marcus,13718 | 3062.33 | 0.00 | 0.00 | 2443.35 | 618.98 |
| Shan, Lacey, K,14957 | 2807.03 | 0.00 | 0.00 | 2181.56 | 625.47 |
| Xie, Cedric, L,19297 | 2542.96 | 0.00 | 0.00 | 782.99 | 1759.97 |
| Suarez, Frank,19309 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Richardson, Morgan, S,26645 | 2800.44 | 0.00 | 0.00 | 2049.10 | 751.34 |
| Gonzalez, Kristi, A,13734 | 4522.50 | 0.00 | 0.00 | 2181.56 | 2340.94 |
| Gomez, Dwayne,12295 | 174.17 | 0.00 | 0.00 | 0.00 | 174.17 |
| Gonzalez, Sergio, S,26357 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Washington, Richard,22074 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Martin, William, R,22078 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Moreno, Victor, L,13771 | 2957.42 | 0.00 | 0.00 | 0.00 | 2957.42 |
| Jones, Matthew, J,27221 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Rubio, Theresa,21743 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Barnes, Lauren, M,26625 | 2827.75 | 0.00 | 0.00 | 2071.42 | 756.33 |
| Prasad, Ronald,24383 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Xie, Shawn, J,16476 | 4715.49 | 0.00 | 0.00 | 2181.56 | 2533.93 |
| Gomez, Kari,12229 | 4415.68 | 0.00 | 0.00 | 2071.42 | 2344.26 |
| Yang, Noah,26602 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Yang, Dennis, P,15003 | 3048.56 | 0.00 | 0.00 | 2443.35 | 605.21 |
| Gutierrez, Krista, R,15071 | 2746.55 | 0.00 | 0.00 | 2181.56 | 564.99 |
| Rivera, Cole, R,13736 | 4478.84 | 0.00 | 0.00 | 2181.56 | 2297.28 |
| Rubio, Erik, C,15064 | 2992.33 | 0.00 | 0.00 | 2443.35 | 548.98 |
| Anderson, Wyatt, M,14284 | 1769.93 | 0.00 | 0.00 | 1000.44 | 769.49 |
| Martin, Cheryl, C,16448 | 6906.89 | 0.00 | 0.00 | 2181.56 | 4725.33 |
| Jenkins, Emily,26676 | 2805.43 | 0.00 | 0.00 | 2049.10 | 756.33 |
| Andersen, Alicia, S,19029 | 3339.41 | 0.00 | 0.00 | 1000.44 | 2338.97 |
Generated 2025-12-22 02:33:51.171 UTC