[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 15 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hall, Angel, H,26807 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| She, Michele, P,29051 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Powell, Dakota, L,24747 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Jordan, Gerald, L,19053 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Robinson, Hannah,25924 | 5819.05 | 0.00 | 3399.99 | 0.00 | 2419.06 |
| Browning, Meredith,21927 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Gao, Clayton, C,22827 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Price, Alexia, L,11202 | 73.98 | 0.00 | 0.00 | 0.00 | 73.98 |
| Richardson, Bryce,11169 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Gonzales, Aaron,18804 | 1810.46 | 0.00 | 0.00 | 0.00 | 1810.46 |
| Martinez, Regina, S,20345 | 2520.83 | 0.00 | 0.00 | 0.00 | 2520.83 |
| Long, Katherine, M,23141 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Nelson, Madeline, K,26121 | 3300.25 | 0.00 | 2071.42 | 0.00 | 1228.83 |
| Zeng, Clayton,14202 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Patel, Adriana, L,29441 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Lewis, Richard, I,21637 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Foster, Justin,21575 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Ross, Mariah, J,12104 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Gray, Zoe, F,23482 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Sanders, Julia, M,27553 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Zhao, Autumn, J,27770 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| King, Carlos, M,24519 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Butler, Maria,16067 | 664.89 | 0.00 | 0.00 | 0.00 | 664.89 |
| Zhu, Jeffery, E,28489 | 786.33 | 0.00 | 0.00 | 0.00 | 786.33 |
| Jiménez, Danny,16252 | 2781.54 | 0.00 | 0.00 | 2181.56 | 599.98 |
| Hill, Thomas, M,26619 | 2972.77 | 0.00 | 0.00 | 2071.42 | 901.35 |
| Sanchez, Chloe,16151 | 639.45 | 0.00 | 0.00 | 0.00 | 639.45 |
| Butler, Tristan,25865 | 4643.83 | 3374.99 | 0.00 | 0.00 | 1268.84 |
| Gray, Ariana, D,11425 | 10528.63 | 0.00 | 0.00 | 2049.10 | 8479.53 |
| Shan, Edwin,12268 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
Generated 2025-12-21 13:33:40.355 UTC