[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 50 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Cabello, Albert, S,17857 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Ma, Claudia, E,11582 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| Jenkins, Julia, R,19156 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Torres, Morgan,21719 | 99.96 | 0.00 | 0.00 | 0.00 | 99.96 |
| Morris, Arianna, W,14999 | 57.51 | 0.00 | 0.00 | 0.00 | 57.51 |
| Williams, Natalie, E,20937 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Bell, Bryce, O,20025 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Taylor, Chloe, R,20433 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Morgan, Bailey,24451 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Rogers, Jacqueline, S,25015 | 2461.55 | 0.00 | 0.00 | 0.00 | 2461.55 |
| Anand, Cedric, P,28400 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Butler, Brandon,12145 | 132.92 | 0.00 | 0.00 | 0.00 | 132.92 |
| Butler, Gabriel,26935 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Schmidt, Johnathan,26366 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Gonzalez, Jack, A,23254 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Washington, Gabrielle,13429 | 4587.03 | 0.00 | 0.00 | 2181.56 | 2405.47 |
| Martin, Rebekah, M,27962 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zhou, Randy, J,21825 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ware, Victoria,13937 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Howard, Alexa,15381 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ross, Angelica, A,22878 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Kumar, April, G,21133 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rai, Peter,19990 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Li, Micah,12829 | 4406.06 | 0.00 | 0.00 | 2049.10 | 2356.96 |
| Martin, Cheryl, C,16448 | 6906.89 | 0.00 | 0.00 | 2181.56 | 4725.33 |
| Blanco, Anne,20014 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Garcia, Ethan,14738 | 1503.58 | 0.00 | 699.10 | 0.00 | 804.48 |
| Rodriguez, Christian, R,21346 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
Generated 2025-12-22 02:09:59.694 UTC