[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ross, Hunter,24722 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Bennett, Devin,27563 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Patterson, Jonathan,29034 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Jenkins, Olivia,19166 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Jackson, Christian, L,27623 | 5984.27 | 3578.27 | 0.00 | 0.00 | 2406.00 |
| Bryant, Ryan, W,25206 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Richardson, Brianna, G,12415 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Smith, Cameron, M,13589 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Nara, Mitchell,17158 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cox, Makayla,24231 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Perry, Mariah,26451 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Richardson, Dalton, W,11679 | 145.96 | 0.00 | 0.00 | 0.00 | 145.96 |
| Bradley, Amanda,25289 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Sharma, Casey, A,12814 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Miller, William,28149 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Griffin, David,21608 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zheng, Autumn, A,19041 | 3089.08 | 0.00 | 699.10 | 0.00 | 2389.98 |
| Martinez, Nicholas, L,16236 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Murphy, Cole,27066 | 33.98 | 0.00 | 0.00 | 33.98 | 0.00 |
| Rogers, Xavier, G,11793 | 101.96 | 0.00 | 0.00 | 66.97 | 34.99 |
| Thompson, Charles, J,13724 | 4476.55 | 0.00 | 0.00 | 2181.56 | 2294.99 |
| Kapoor, Raymond, L,20928 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Jenkins, Aidan,23030 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Bryant, Natalie, L,28095 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Flores, Isabel,23715 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sanz, Javier, E,19932 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Moreno, Victor, L,13771 | 2957.42 | 0.00 | 0.00 | 0.00 | 2957.42 |
| Hill, Isabella, P,27310 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Perez, Gabriel, E,25282 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Nelson, Blake, I,13086 | 4805.62 | 0.00 | 2443.35 | 0.00 | 2362.27 |
| Long, Mya, O,28191 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
Generated 2025-12-22 02:09:34.044 UTC