[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 77 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rogers, Megan, M,19857 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gonzales, Dylan, J,19398 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Williams, James, J,11152 | 2294.99 | 0.00 | 0.00 | 2294.99 | 0.00 |
| Washington, Kyle, C,29255 | 4389.59 | 0.00 | 3578.27 | 0.00 | 811.32 |
| Ma, Susan, A,13948 | 4562.03 | 0.00 | 0.00 | 2181.56 | 2380.47 |
| Morris, Grace, A,20006 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Zhou, Suzanne,12130 | 7987.91 | 0.00 | 0.00 | 3254.89 | 4733.02 |
| Diaz, Abigail, G,22641 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Lal, Aaron,13154 | 2309.97 | 0.00 | 0.00 | 0.00 | 2309.97 |
| Russell, Aidan,14467 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Isaiah, R,12184 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Barnes, Gabrielle,14883 | 1828.58 | 0.00 | 699.10 | 0.00 | 1129.48 |
| Garcia, Cory, B,21546 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanz, Daisy,29372 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Ramirez, Sara, A,12757 | 106.96 | 0.00 | 0.00 | 0.00 | 106.96 |
Generated 2025-12-22 04:09:50.230 UTC