[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 203 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gray, Lauren,20018 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sharma, Johnny,19834 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Chen, Damien, A,23979 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Hall, Emily,14526 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gonzales, Elizabeth, E,19689 | 680.94 | 0.00 | 0.00 | 0.00 | 680.94 |
| Patterson, Angela,21619 | 556.26 | 0.00 | 0.00 | 0.00 | 556.26 |
| Luo, Marshall,19380 | 1934.75 | 0.00 | 0.00 | 782.99 | 1151.76 |
| Jimenez, Lori, C,21024 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Liang, Karen, M,21048 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Scott, Lucas, L,11866 | 42.95 | 0.00 | 0.00 | 0.00 | 42.95 |
| Long, Alexandria, E,11714 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Rivera, Brianna, A,21234 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Ms., Serventi, Alice, J.,16936 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Robinson, Jonathan,13235 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Bryant, Grace, J,20371 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Powell, Isabella, L,20923 | 2374.80 | 0.00 | 0.00 | 782.99 | 1591.81 |
| Mitchell, Jada,11851 | 84.99 | 0.00 | 0.00 | 0.00 | 84.99 |
| Russell, Tristan,25003 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Johnson, Grace, M,18093 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Alonso, Monique,24842 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Diaz, Albert, A,12436 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Hu, Martha, C,13464 | 4501.55 | 0.00 | 0.00 | 2181.56 | 2319.99 |
| Gonzalez, Toni, E,26575 | 2890.41 | 0.00 | 0.00 | 2049.10 | 841.31 |
| Garcia, Jasmine, A,22297 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Hernandez, Mary, D,17272 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Griffin, Megan, A,22287 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lewis, Michael, R,14782 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Kapoor, Cory, L,14939 | 8367.30 | 0.00 | 3578.27 | 0.00 | 4789.03 |
| Sanchez, Julia, B,28003 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perry, Samantha, F,24776 | 91.58 | 0.00 | 0.00 | 0.00 | 91.58 |
Generated 2025-12-24 06:25:16.280 UTC