[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1014 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Hernandez, Bailey, J,28626 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| James, Xavier, C,28595 | 49.99 | 0.00 | 0.00 | 49.99 | 0.00 |
| Patterson, Samantha,14360 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Sharma, Shaun, L,14148 | 4406.74 | 0.00 | 3578.27 | 0.00 | 828.47 |
| Liang, Jaclyn,21632 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Andersen, Cassie,14428 | 8321.31 | 0.00 | 3578.27 | 2413.06 | 2329.98 |
| Hughes, Fernando,20120 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Zhu, Cedric, T,20723 | 143.96 | 0.00 | 0.00 | 0.00 | 143.96 |
| Yuan, Nina, R,11531 | 5875.55 | 0.00 | 3578.27 | 2297.28 | 0.00 |
| Patel, Edgar, M,16880 | 2343.96 | 0.00 | 0.00 | 0.00 | 2343.96 |
| Jenkins, Ashley,21091 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Zhu, Tamara,12607 | 6489.51 | 0.00 | 3578.27 | 2322.28 | 588.96 |
| Moore, Benjamin, D,12913 | 5922.53 | 0.00 | 3578.27 | 0.00 | 2344.26 |
| Perry, Aaron,13195 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Coleman, Julia,11303 | 5875.55 | 0.00 | 3578.27 | 2297.28 | 0.00 |
| Patterson, Spencer, W,16925 | 1764.96 | 0.00 | 0.00 | 1764.96 | 0.00 |
| Kumar, Gabriel, R,18137 | 3043.06 | 0.00 | 699.10 | 0.00 | 2343.96 |
| Arthur, Abby,14800 | 4390.69 | 0.00 | 3578.27 | 0.00 | 812.42 |
| Tang, Tamara,28470 | 3399.99 | 0.00 | 3399.99 | 0.00 | 0.00 |
| Powell, Jessica,14769 | 4397.75 | 0.00 | 3578.27 | 0.00 | 819.48 |
| Wright, Jenna,11291 | 5873.26 | 0.00 | 3578.27 | 2294.99 | 0.00 |
| Morris, Gabriella, F,13174 | 4558.52 | 0.00 | 2181.56 | 2376.96 | 0.00 |
| Clark, Logan,18039 | 2450.08 | 0.00 | 699.10 | 0.00 | 1750.98 |
| Sun, Cedric,17985 | 6016.66 | 0.00 | 0.00 | 3696.67 | 2319.99 |
| Andersen, Lindsey, S,13261 | 3622.31 | 0.00 | 0.00 | 0.00 | 3622.31 |
| Yanagishima, Daisuke,26011 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 |
| Evans, Gabriella, K,21356 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Cook, Ariana,11525 | 5935.55 | 0.00 | 3578.27 | 2357.28 | 0.00 |
Generated 2024-09-21 13:54:54.144 UTC