[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 47 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Campbell, Courtney,29228 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Rivera, Kimberly,12401 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Ma, Steve,21098 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Howard, Isabella, J,28869 | 4355.61 | 0.00 | 3578.27 | 0.00 | 777.34 |
| Ms., Sherman, Megan,24561 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Cook, Patrick, K,27577 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Perry, Trevor, E,21344 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Kelly, Jessica,21261 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Andersen, Lindsay,27142 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Wright, Jordan, E,27065 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Kapoor, Erick, J,27816 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Martin, Julia,18790 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Anderson, Justin,28660 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Brown, Daniel, J,22752 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Raje, Kathryn, A,17816 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
Generated 2025-12-22 02:00:15.391 UTC