[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Liang, Leah,16412 | 4921.59 | 0.00 | 0.00 | 2443.35 | 2478.24 |
| Ma, Trisha, E,13039 | 3282.83 | 0.00 | 2443.35 | 0.00 | 839.48 |
| Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 37.29 | 162.91 |
| Simmons, Ethan,13210 | 4501.55 | 0.00 | 2181.56 | 0.00 | 2319.99 |
| Fernandez, Nancy,14854 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Lu, Wesley, P,26063 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Roberts, Ian, M,25424 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Adams, Isabella,15715 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Sai, Martin, L,21221 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Becker, Jodi,26043 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Harris, Daniel, T,13085 | 3089.80 | 0.00 | 2443.35 | 0.00 | 646.45 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Thomas, Hunter,22863 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Kelly, Jessica,21261 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Kumar, Alison,21200 | 3932.54 | 0.00 | 2181.56 | 0.00 | 1750.98 |
| Luo, Calvin, T,19172 | 1609.41 | 0.00 | 1000.44 | 0.00 | 608.97 |
| Blue, Richard,12006 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| Phillips, Allison,20353 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Chande, Drew, R,20930 | 2363.79 | 0.00 | 0.00 | 782.99 | 1580.80 |
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 0.00 | 676.93 |
| Carter, Sydney,12959 | 203.92 | 0.00 | 0.00 | 0.00 | 203.92 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Gonzales, Jackson,19019 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Long, Caleb, P,25046 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Hughes, Ian,21399 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Russell, Oscar, A,12140 | 118.17 | 0.00 | 0.00 | 0.00 | 118.17 |
| Brooks, Bryce,12061 | 140.17 | 0.00 | 0.00 | 74.98 | 65.19 |
| Goldstein, Alvin,21454 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Gomez, Robyn,16046 | 3963.14 | 0.00 | 2443.35 | 0.00 | 1519.79 |
| Walker, Kayla,27679 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Bryant, Nathan,21450 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
Generated 2025-12-24 06:47:37.377 UTC