[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 62 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Miller, Natalie, R,25910 | 4623.83 | 0.00 | 3399.99 | 0.00 | 1223.84 |
| Wu, Barbara, M,14532 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| James, Trinity, A,15161 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Alexander, Jocelyn,11165 | 102.49 | 0.00 | 0.00 | 0.00 | 102.49 |
| Gutierrez, Beth, C,11395 | 5729.97 | 0.00 | 3399.99 | 0.00 | 2329.98 |
| Nelson, Carlos,28977 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Moore, Joseph, L,25392 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Griffin, David,21608 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zhao, Darryl,15656 | 2992.33 | 0.00 | 0.00 | 2443.35 | 548.98 |
| Ashe, Brandi,23749 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Yang, Austin, H,22992 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Yang, Samuel, R,15271 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramos, Ross,20390 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Richardson, Bryce,11169 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Dominguez, Bruce,28741 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
Generated 2025-12-22 00:22:52.124 UTC