[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhu, Barbara, H,21005 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Anderson, Andrew,26059 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Lopez, Madeline, G,12044 | 105.95 | 0.00 | 0.00 | 0.00 | 105.95 |
| Torres, Francis,17223 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Mehta, Summer, E,18415 | 2454.98 | 0.00 | 0.00 | 0.00 | 2454.98 |
| Hughes, Trevor, L,13552 | 5922.53 | 0.00 | 3578.27 | 0.00 | 2344.26 |
| Russell, Angela,12049 | 171.44 | 0.00 | 0.00 | 0.00 | 171.44 |
| Phillips, Kevin, L,20270 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Bailey, Jesse, A,18061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chande, Nicolas, J,12720 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Garcia, Miguel, L,27032 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Allen, Stephanie,24518 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Albrecht, Brian, T,13677 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Richardson, Danielle,22884 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Rodriguez, Jacob,14394 | 3344.70 | 0.00 | 0.00 | 1000.44 | 2344.26 |
| Madan, Preston,20074 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Garcia, Joel, A,11544 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Long, Ian, C,11924 | 5897.23 | 0.00 | 3578.27 | 0.00 | 2318.96 |
| McDonald, Elijah,18911 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Perry, Riley,25079 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Srini, Jarrod,27182 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Russell, Thomas,22338 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Sanders, Nathaniel, L,14619 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Edwards, Samuel,12024 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Alvarez, Wendy, V,12129 | 8557.41 | 0.00 | 0.00 | 2071.42 | 6485.99 |
| Malhotra, Molly,24551 | 142.45 | 0.00 | 0.00 | 0.00 | 142.45 |
| Ortega, Randall, C,15540 | 3124.96 | 0.00 | 0.00 | 782.99 | 2341.97 |
| Foster, Ian, A,16485 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Taylor, Seth, R,26509 | 2800.44 | 0.00 | 0.00 | 2049.10 | 751.34 |
| Richardson, Brianna, G,12415 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
Generated 2025-12-22 02:59:32.332 UTC