[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 20 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wilson, Jennifer,14435 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Lewis, Ashley, L,12960 | 51.27 | 0.00 | 0.00 | 0.00 | 51.27 |
| Srini, Meredith, V,24882 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Suri, Emmanuel,26346 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Andersen, Dawn,16473 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Simmons, Vanessa, J,28659 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Ray, Regina, B,25142 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hughes, Thomas, M,17420 | 2370.22 | 0.00 | 0.00 | 0.00 | 2370.22 |
| Srini, Cassandra, S,20520 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Hayes, Jacqueline, H,11409 | 4444.07 | 0.00 | 0.00 | 4444.07 | 0.00 |
| White, Marcus,20066 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Washington, Miguel, C,18778 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-22 09:32:05.511 UTC