[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanchez, Abigail,28192 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Bryant, Aaron,12067 | 133.96 | 0.00 | 0.00 | 0.00 | 133.96 |
| Torres, Evan,19543 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Liang, Arturo, W,24542 | 123.99 | 0.00 | 0.00 | 0.00 | 123.99 |
| Alan, Alisha, M,28740 | 3191.91 | 0.00 | 0.00 | 2071.42 | 1120.49 |
| Campbell, Sydney,13465 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Watson, Mackenzie,18999 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Lopez, Henry, M,22010 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Peterson, Abigail, L,23448 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Ross, Alexandria,24670 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Moreno, Mathew,26090 | 5819.05 | 0.00 | 3399.99 | 0.00 | 2419.06 |
| Hill, Devin,19660 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Xu, Stacey,21513 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Butler, Brianna, B,25278 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Shan, Katrina, C,27814 | 182.78 | 0.00 | 0.00 | 0.00 | 182.78 |
Generated 2025-12-21 13:35:45.996 UTC