[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 47 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lopez, Amanda, J,24448 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Rivera, Melissa, S,28759 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Tang, Jerry,27765 | 742.35 | 0.00 | 0.00 | 742.35 | 0.00 |
| Ma, Kelvin, E,13825 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Coleman, Lauren,13419 | 4476.55 | 0.00 | 0.00 | 2181.56 | 2294.99 |
| Rai, Misty, H,12457 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Torres, Steven, W,17666 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Bell, Ariana,29149 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Long, Samantha,11128 | 143.94 | 0.00 | 0.00 | 0.00 | 143.94 |
| Nath, Mitchell, W,17452 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Young, Kevin,19883 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Alvarez, Melinda,27655 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Jimenez, Theodore, M,27254 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Gonzales, Sydney, B,13371 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Griffin, Dylan,19153 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Raji, Rafael, C,25619 | 1273.83 | 0.00 | 0.00 | 0.00 | 1273.83 |
| Campbell, Courtney,29228 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Hayes, Edward,15796 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Shen, Ricardo,14905 | 163.99 | 0.00 | 0.00 | 0.00 | 163.99 |
| Simmons, Caroline,13912 | 4548.02 | 0.00 | 0.00 | 2181.56 | 2366.46 |
| Zhang, Austin,19395 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hughes, Abigail, G,24764 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Richardson, Kaylee, L,17560 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Robinson, Tyler, A,26325 | 4478.46 | 0.00 | 0.00 | 2071.42 | 2407.04 |
| Lewis, Dylan,14153 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Nelson, Jason, R,25871 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Anderson, Logan, C,15821 | 30.97 | 0.00 | 0.00 | 30.97 | 0.00 |
| Jai, Terry, P,18046 | 2435.08 | 0.00 | 699.10 | 0.00 | 1735.98 |
| Williams, Chloe, A,28106 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Clark, Xavier, L,18967 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
Generated 2025-12-23 06:06:25.918 UTC