[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 24 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Allen, Bailey, F,27218 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Alonso, Monique,24842 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Harris, Kaitlyn,24927 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Suarez, Diane, L,22445 | 2490.18 | 0.00 | 0.00 | 2490.18 | 0.00 |
| Chander, Jerry, M,28180 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Nelson, Mason,21334 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Cook, Nicole,15979 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sara, Cindy, M,14930 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Green, Thomas,18856 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Chandra, Levi,12093 | 46.28 | 0.00 | 0.00 | 0.00 | 46.28 |
| Henderson, Carson,27453 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Flores, Justin,18774 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Gonzales, Stephanie,16799 | 1700.99 | 0.00 | 0.00 | 1700.99 | 0.00 |
| Wilson, Miguel,13414 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
Generated 2025-12-22 04:43:40.401 UTC