[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 63 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jiménez, Casey,22438 | 616.95 | 0.00 | 0.00 | 0.00 | 616.95 |
| Srini, Lydia, J,28499 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Reed, Jared, M,28531 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Cai, Mandy, A,27109 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Harris, Richard,15248 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Rivera, Zoe,25413 | 1228.83 | 0.00 | 0.00 | 0.00 | 1228.83 |
| Xu, Franklin, D,17103 | 6935.08 | 0.00 | 0.00 | 2181.56 | 4753.52 |
| Luo, Corey,19936 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Alan, Xavier,15384 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gonzales, Marissa,16462 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Bryant, Maria, E,26370 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Taylor, Alexander, E,14588 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Xu, Wayne, M,18014 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Perez, Troy, D,16284 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Butler, Brittany,28641 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
Generated 2025-12-23 12:09:55.115 UTC