[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Henderson, Jack, M,17581 | 2369.45 | 0.00 | 0.00 | 0.00 | 2369.45 |
| Long, Logan,25098 | 1251.12 | 0.00 | 0.00 | 0.00 | 1251.12 |
| Rai, Nichole,21496 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Sharma, Mindy,21350 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Hughes, Angelica, G,18477 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Campbell, Samuel,18109 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| Carlson, Tabitha,14688 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Chande, Jenny, B,17111 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vance, Rachael,26899 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ruiz, Darren, A,27835 | 43.46 | 0.00 | 0.00 | 0.00 | 43.46 |
| Shan, Shawn, E,15101 | 6943.55 | 0.00 | 2181.56 | 0.00 | 4761.99 |
| Thomas, Brandon, L,21770 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Lu, Autumn,15001 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Sun, Jeffery, J,24864 | 155.72 | 0.00 | 0.00 | 0.00 | 155.72 |
| Xu, Gilbert,13145 | 2337.27 | 0.00 | 0.00 | 0.00 | 2337.27 |
| Jai, Cristina, R,29363 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Carter, Evan, K,18780 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Alvarez, Wendy, V,12129 | 8557.41 | 0.00 | 0.00 | 2071.42 | 6485.99 |
| Hall, Sydney,12099 | 43.99 | 0.00 | 0.00 | 0.00 | 43.99 |
| Morris, Trinity, S,28965 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Peterson, Danielle, L,28970 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Rogers, Riley,26648 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Perry, Kyle, J,25197 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Anderson, Nathan,14876 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Wilson, Justin,11842 | 98.97 | 0.00 | 0.00 | 0.00 | 98.97 |
| Clark, Matthew, L,13394 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Cai, Lisa,11241 | 11469.19 | 0.00 | 0.00 | 4379.08 | 7090.11 |
| Gill, Janet, B,25192 | 2480.99 | 0.00 | 0.00 | 0.00 | 2480.99 |
| Romero, Albert,16131 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Sharma, Alison,21094 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Schmidt, Johnathan,26366 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
Generated 2025-12-21 22:38:18.110 UTC