[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1077 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Luo, Tonya, A,29107 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Fernandez, Nancy,14854 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| She, Dale, L,19441 | 1567.46 | 0.00 | 0.00 | 782.99 | 784.47 |
| Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Bennett, Kaitlyn, L,16942 | 2751.42 | 0.00 | 1000.44 | 0.00 | 1750.98 |
| Deng, Keith,13059 | 3089.80 | 0.00 | 2443.35 | 646.45 | 0.00 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Kumar, Alison,21200 | 3932.54 | 0.00 | 2181.56 | 0.00 | 1750.98 |
| Sai, Erick, L,11484 | 4985.38 | 0.00 | 2071.42 | 2364.98 | 548.98 |
| Chande, Drew, R,20930 | 2363.79 | 0.00 | 0.00 | 782.99 | 1580.80 |
| Prasad, Monica, C,21019 | 629.96 | 0.00 | 0.00 | 0.00 | 629.96 |
| Sanders, Jesse,20758 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| James, Michelle, M,13093 | 4778.33 | 0.00 | 2443.35 | 0.00 | 2334.98 |
| Long, Caleb, P,25046 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Deng, Andres,13667 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Coleman, Marcus, J,28663 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Walker, Kayla,27679 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Gomez, Theodore,13503 | 101.25 | 0.00 | 0.00 | 0.00 | 101.25 |
| Dominguez, Walter,12576 | 2653.07 | 0.00 | 2049.10 | 0.00 | 603.97 |
| Turner, Edward, S,20474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Williams, Charles,20325 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Bailey, Rachel, R,18921 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Wood, Nicole,16010 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Yang, Tiffany, K,21215 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Fernandez, Ruben,19927 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Henderson, Natalie,19273 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Adams, Isaac,26174 | 2071.42 | 0.00 | 2071.42 | 0.00 | 0.00 |
| Raje, Lacey, T,12358 | 6787.76 | 0.00 | 2071.42 | 0.00 | 4716.34 |
| Luo, Ricardo,26380 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Zhang, Aaron, A,22768 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
Generated 2025-12-23 12:16:05.720 UTC