[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 969 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ward, Hailey, J,11315 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Rodriguez, Tina,27888 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Kapoor, Edgar,24134 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rodriguez, José,12527 | 86.96 | 0.00 | 0.00 | 0.00 | 86.96 |
| Martinez, Nancy, E,13712 | 4503.84 | 0.00 | 0.00 | 2181.56 | 2322.28 |
| Diaz, Jeremiah, S,26283 | 3371.25 | 0.00 | 2071.42 | 0.00 | 1299.83 |
| Garcia, Ashley,21293 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Lin, Micah,19292 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Guo, Jeffery, C,20926 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Kumar, Kyle,25950 | 54.25 | 0.00 | 0.00 | 0.00 | 54.25 |
| Scott, Blake, D,14638 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Peterson, Paige,13754 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Ramos, Sheila,15076 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Cook, Lucas, C,23955 | 44.22 | 0.00 | 0.00 | 0.00 | 44.22 |
| Raji, Ricardo,27335 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suri, Heidi,18480 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Murphy, Alyssa, O,25072 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 |
| Peterson, Nicole,21385 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Patterson, Madison,17779 | 4250.21 | 0.00 | 0.00 | 1000.44 | 3249.77 |
| Lopez, Marco,11429 | 10468.38 | 0.00 | 0.00 | 2071.42 | 8396.96 |
| Henderson, Jonathan, M,11143 | 48.56 | 0.00 | 0.00 | 0.00 | 48.56 |
| Jai, Leonard, R,26282 | 123.95 | 0.00 | 0.00 | 0.00 | 123.95 |
| Butler, Arianna, C,23713 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Hill, Angel, E,22222 | 94.46 | 0.00 | 0.00 | 0.00 | 94.46 |
| Bailey, Chloe, L,14564 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Hernandez, Kathleen,24147 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rivera, Cole, R,13736 | 4478.84 | 0.00 | 0.00 | 2181.56 | 2297.28 |
| Lal, Luis,15538 | 1595.41 | 0.00 | 0.00 | 782.99 | 812.42 |
| Lewis, Anna,26304 | 3263.95 | 0.00 | 0.00 | 2049.10 | 1214.85 |
| Turner, Hunter,18854 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Perez, Lydia,25589 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
Generated 2025-12-23 05:22:04.817 UTC