[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gao, Clayton, C,22827 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Hayes, Vanessa,16471 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Liang, Arturo, W,24542 | 123.99 | 0.00 | 0.00 | 0.00 | 123.99 |
| Torres, Sara, D,18399 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Hernandez, Stacy,17811 | 6989.58 | 0.00 | 0.00 | 2181.56 | 4808.02 |
| Romero, Danny,26867 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Blanco, Sabrina,13564 | 5932.22 | 0.00 | 3578.27 | 0.00 | 2353.95 |
| Wilson, Justin,11842 | 98.97 | 0.00 | 0.00 | 0.00 | 98.97 |
| Price, Kayla,28188 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Butler, Aidan, B,14490 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cai, Clarence, L,22609 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Miller, Miguel,18689 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| She, Jaclyn, G,17376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Griffin, Connor, S,12775 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Peterson, Emma, K,18416 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Cook, Kimberly, R,28190 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Stewart, Sean,23886 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Murphy, Hailey, F,19008 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Rodriguez, Cameron, L,11301 | 131.26 | 0.00 | 0.00 | 0.00 | 131.26 |
| Blue, Natalie, T,20307 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Perez, Jada,17168 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hall, Seth,14487 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hu, Dawn, G,20797 | 14.23 | 0.00 | 0.00 | 0.00 | 14.23 |
| Navarro, Tanya, C,24130 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Ruiz, Teresa,13666 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Sharma, Warren, N,21705 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Watson, Katherine, L,15190 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Young, Isabella,11857 | 124.97 | 0.00 | 0.00 | 0.00 | 124.97 |
| Collins, Sydney, V,13733 | 4553.52 | 0.00 | 0.00 | 2181.56 | 2371.96 |
| Sara, Jay, M,13462 | 4558.01 | 0.00 | 0.00 | 2181.56 | 2376.45 |
Generated 2025-12-23 04:00:08.902 UTC