[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1031 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mehta, Tammy,12816 | 4494.02 | 0.00 | 0.00 | 2049.10 | 2444.92 |
| Pal, Shawn,27286 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Russell, James, D,15890 | 1375.26 | 0.00 | 0.00 | 782.99 | 592.27 |
| James, Ian, A,15899 | 3133.95 | 0.00 | 0.00 | 782.99 | 2350.96 |
| Alexander, Faith, A,27276 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Gray, Ariana, D,11425 | 10528.63 | 0.00 | 0.00 | 2049.10 | 8479.53 |
| Blanco, Tyrone, F,19458 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Jimenez, Diane,20979 | 1947.46 | 0.00 | 0.00 | 782.99 | 1164.47 |
| Jenkins, Ethan, F,27431 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Wood, Jeremy, C,27277 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Nath, Jenny,27281 | 4540.47 | 0.00 | 0.00 | 2071.42 | 2469.05 |
| Luo, Jenny, L,19474 | 1589.75 | 0.00 | 0.00 | 782.99 | 806.76 |
| Lopez, Ruth, D,17902 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Wilson, David, M,15908 | 1413.93 | 0.00 | 0.00 | 782.99 | 630.94 |
| Wright, Chloe,14420 | 3320.43 | 0.00 | 0.00 | 1000.44 | 2319.99 |
| Jenkins, Brianna, P,27455 | 4532.97 | 0.00 | 0.00 | 2071.42 | 2461.55 |
| Wang, Candice,19288 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Cai, Alejandro, J,13938 | 3071.01 | 0.00 | 0.00 | 2181.56 | 889.45 |
| Richardson, Amanda,15888 | 3178.95 | 0.00 | 0.00 | 782.99 | 2395.96 |
| Jones, Jennifer, L,12467 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Chande, Bridget, E,12379 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Price, Julia, A,16924 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Chander, Kurt, F,13176 | 4753.32 | 0.00 | 2443.35 | 0.00 | 2309.97 |
| Harrison, Thomas,12362 | 5904.23 | 0.00 | 3578.27 | 0.00 | 2325.96 |
| Jackson, Christopher, C,19768 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Garcia, Julia, B,11304 | 122.21 | 0.00 | 0.00 | 0.00 | 122.21 |
| Henderson, Brittany, W,26071 | 89.46 | 0.00 | 0.00 | 0.00 | 89.46 |
| Sharma, Eric,19809 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Phillips, Kevin, L,20270 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Wilson, Wyatt, L,15946 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
Generated 2025-12-23 07:21:38.716 UTC