[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 62 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Johnson, Jose, L,16100 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Wright, Allison, R,16084 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kennedy, Sheena,25495 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thompson, Olivia,15408 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Serrano, Meghan, A,20391 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Martin, Emily, T,13487 | 4533.52 | 0.00 | 0.00 | 2181.56 | 2351.96 |
| Gray, Garrett, N,20169 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Xie, Ashlee, S,26943 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Kelly, Katherine,20016 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Yuan, Warren, P,19091 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Nath, Alejandro, J,24866 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Bailey, Jesse, A,18061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Peterson, Arianna, J,24989 | 36.59 | 0.00 | 0.00 | 36.59 | 0.00 |
| Chen, Noah, L,26290 | 3295.26 | 0.00 | 2071.42 | 0.00 | 1223.84 |
| Jenkins, Luke,26084 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 |
Generated 2025-12-21 19:44:49.941 UTC