[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Winston, Alexandra, A,22675 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Murphy, Isabella,22645 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Gray, Ariana, D,11425 | 10528.63 | 0.00 | 0.00 | 2049.10 | 8479.53 |
| Ramos, Jonathon, A,27385 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Bailey, Faith, D,25846 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Martinez, Robert, L,23298 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Lopez, Kaitlyn,21754 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Long, Jessica, R,16808 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Rowe, Sheila,28388 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Sandoval, Briana, M,19197 | 4609.74 | 0.00 | 0.00 | 1000.44 | 3609.30 |
| Moreno, Armando,11593 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Ye, Colin,22501 | 2566.80 | 0.00 | 0.00 | 0.00 | 2566.80 |
| Smith, Preston, J,27409 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Phillips, Julia,14609 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Dale,17818 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Goel, Shaun, L,22417 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rubio, Latasha,11246 | 10575.33 | 0.00 | 3374.99 | 2329.98 | 4870.36 |
| Carter, Robert,17681 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Moreno, Jaime,20870 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Ruiz, Deanna, N,24833 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Long, Ian, C,11924 | 5897.23 | 0.00 | 3578.27 | 0.00 | 2318.96 |
| Washington, Kevin, C,11939 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Mitchell, Connor, L,22271 | 612.95 | 0.00 | 0.00 | 0.00 | 612.95 |
| Gray, Chase, J,15688 | 6221.52 | 0.00 | 0.00 | 2181.56 | 4039.96 |
| Shen, Alicia, D,13575 | 9458.18 | 0.00 | 2181.56 | 0.00 | 7276.62 |
| Sun, Jon,12100 | 129.47 | 0.00 | 0.00 | 0.00 | 129.47 |
| Wood, Mya, L,18787 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sanz, Beth,14462 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Alvarez, Jonathon, D,12752 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Allen, Seth, M,12946 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Robinson, Isabella, P,20641 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
Generated 2025-12-22 02:32:34.159 UTC