[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 73 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ramos, Gary, S,22248 | 1134.47 | 0.00 | 0.00 | 0.00 | 1134.47 |
| Madan, Molly, A,15623 | 7246.87 | 0.00 | 0.00 | 2443.35 | 4803.52 |
| Powell, Marcus, A,20366 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Davis, David,22159 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Jenkins, Zachary,17665 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ruiz, Billy, M,26500 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Gill, Linda,17758 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Dominguez, Billy, M,24103 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Lopez, Devin,24492 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Thompson, Megan, S,17578 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rivera, Lauren, C,21317 | 108.95 | 0.00 | 0.00 | 0.00 | 108.95 |
| Pal, Bridget,20787 | 1134.47 | 0.00 | 0.00 | 0.00 | 1134.47 |
| Martinez, Kaitlin,15750 | 3087.97 | 0.00 | 0.00 | 782.99 | 2304.98 |
| Stewart, Christina, R,25296 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
Generated 2025-12-23 07:24:43.115 UTC