[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hill, Rebecca, C,15424 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Alexander, Kevin,12411 | 159.99 | 0.00 | 0.00 | 0.00 | 159.99 |
| Griffin, Melanie, A,26517 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Madan, Kaitlin,17124 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Morgan, Emma,29159 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Nelson, Jada,21357 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Shan, Raul, L,19485 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Chavez, Andres, G,23555 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Morgan, Cody,24447 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Russell, Gabrielle, J,28671 | 4320.62 | 0.00 | 3578.27 | 742.35 | 0.00 |
| Griffin, Nathan,16147 | 2367.20 | 0.00 | 0.00 | 0.00 | 2367.20 |
| Cooper, Michelle, L,17822 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Patterson, Marcus, D,23843 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Yang, Alisha,16266 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Murphy, Cody,18613 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Clark, Jeremy, J,18323 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Anderson, Andrew,26059 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| James, Brianna,17010 | 2384.97 | 0.00 | 0.00 | 0.00 | 2384.97 |
| Xie, Ashlee, S,26943 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Rivera, Jared,21781 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Lal, Sharon, L,17891 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Vazquez, Kathleen, M,12500 | 4475.38 | 0.00 | 0.00 | 2071.42 | 2403.96 |
| Robinson, Katherine,15483 | 3120.26 | 0.00 | 0.00 | 782.99 | 2337.27 |
| Simmons, Ryan,25148 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
Generated 2025-12-24 05:59:03.429 UTC