[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 28 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Ramos, Lori, M,13559 | 2930.44 | 0.00 | 0.00 | 0.00 | 2930.44 | 0.00 |
| Morris, Alexandra,20457 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 | 0.00 |
| Blanco, Paula,12538 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 | 0.00 |
| Rodriguez, Seth,14203 | 7081.46 | 0.00 | 0.00 | 2181.56 | 4899.90 | 0.00 |
| Huang, Stacey,25443 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 | 0.00 |
| Carlson, Melody, K,21008 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 | 0.00 |
| Shan, Gilbert, B,22652 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 | 0.00 |
| Fernandez, Brett, L,16214 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 | 0.00 |
| Reed, Sydney,23038 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 | 0.00 |
| Weber, Clifford, A,19321 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 | 0.00 |
| Brooks, Danielle,19999 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 | 0.00 |
| Andersen, Terrence, E,22016 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 | 0.00 |
| Richardson, Christina,12199 | 194.98 | 0.00 | 0.00 | 0.00 | 194.98 | 0.00 |
| Cooper, Ian,19151 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Hernandez, Robert,12418 | 5969.72 | 0.00 | 3578.27 | 0.00 | 2391.45 | 0.00 |
| Rana, Jillian,20044 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Madan, Jermaine, C,15091 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Jones, Victoria, S,13450 | 4773.33 | 0.00 | 0.00 | 2443.35 | 2329.98 | 0.00 |
| Jai, Colleen,23831 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 | 0.00 |
| Hu, Stacey,12696 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 | 0.00 |
| Luo, Damien, L,25696 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 | 0.00 |
| Beck, Alison,28889 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 | 0.00 |
| Howard, Nicole, M,28183 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Fernandez, Tabitha, A,25724 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 | 0.00 |
| Carlson, Neil, M,19226 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 | 0.00 |
| Xu, Jon, D,16572 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 | 0.00 |
| Andersen, Alisha,25460 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 | 0.00 |
| Richardson, Jasmine,20026 | 1212.97 | 0.00 | 0.00 | 0.00 | 1212.97 | 0.00 |
Generated 2026-01-04 08:53:08.179 UTC