[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1218 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Smith, Alyssa,26083 | 5794.05 | 0.00 | 3374.99 | 0.00 | 2419.06 |
| Long, Ashley,24688 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Rubio, Lawrence,24761 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Torres, Steven, W,17666 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Perez, Edward, J,26471 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Richardson, Richard,23025 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Patterson, Abigail,20643 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Jordan, Joel, M,20593 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Torres, Stephanie,11182 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Jenkins, Jonathan,24107 | 123.99 | 0.00 | 0.00 | 0.00 | 123.99 |
| Sai, Edgar,11879 | 107.42 | 0.00 | 0.00 | 0.00 | 107.42 |
| Wang, Ernest,17038 | 2442.28 | 0.00 | 0.00 | 0.00 | 2442.28 |
| Lopez, Kaylee, E,17398 | 2354.98 | 0.00 | 0.00 | 0.00 | 2354.98 |
| Garcia, Joel, A,11544 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Collins, Alexandra,12548 | 4368.06 | 0.00 | 0.00 | 2049.10 | 2318.96 |
| Lewis, Jonathan, C,27039 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Russell, Edward,24642 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Long, Marcus, J,18087 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Sharma, Chad, J,23847 | 722.77 | 0.00 | 0.00 | 0.00 | 722.77 |
| Davis, Andrew, C,18794 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Lee, Miguel,12749 | 5915.54 | 0.00 | 3578.27 | 0.00 | 2337.27 |
| Johnson, Victoria, E,28681 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Navarro, Kristi,27115 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Sanchez, Ann, D,25431 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Hill, Jose,18779 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Andersen, Russell,14695 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Tang, Kristin, A,25794 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Rivera, Timothy, A,21737 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Deng, Dawn, L,16439 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Patterson, Alexandra, A,19489 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Robinson, Alexander, J,15737 | 3117.23 | 0.00 | 0.00 | 782.99 | 2334.24 |
Generated 2025-12-24 07:20:39.365 UTC