[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 17 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Beck, Alison,28889 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Perez, Richard, L,13808 | 828.47 | 0.00 | 0.00 | 0.00 | 828.47 |
| Yuan, Wayne, V,17088 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Powell, Anna, J,23680 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Perez, Allison, C,27533 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Coleman, Caroline,16568 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Lee, Jessica,19636 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Ma, Gilbert,21419 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Smith, Samantha, J,14479 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| Jenkins, Elizabeth, I,14166 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Coleman, Jacqueline, A,17212 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
| Pal, Tommy,13840 | 3010.03 | 0.00 | 0.00 | 2181.56 | 828.47 |
| Brooks, Juan,18516 | 2404.91 | 0.00 | 0.00 | 0.00 | 2404.91 |
| Kelly, Megan,24784 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
Generated 2025-12-22 06:54:42.684 UTC