[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 73 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhao, Dawn,24195 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Luo, Mitchell, E,28895 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Patterson, Miguel,27665 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Wright, Alex,19758 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hu, Damien,12029 | 54.97 | 0.00 | 0.00 | 0.00 | 54.97 |
| Perez, Ruben,18556 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Moore, James, Y,18753 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Morris, Sebastian,16235 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Sharma, Luke,23005 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Flores, Alexis,23193 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Huang, Ronnie,20047 | 614.98 | 0.00 | 0.00 | 0.00 | 614.98 |
| Mehta, Roy,19371 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Mitchell, Timothy, E,22892 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Deng, Darrell, A,25450 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Tang, Franklin, N,26940 | 1273.83 | 0.00 | 0.00 | 0.00 | 1273.83 |
| Allen, Isaac, J,22261 | 561.48 | 0.00 | 0.00 | 561.48 | 0.00 |
| Jai, David,23483 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Perez, Stanley,15818 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blanco, Tanya, W,19324 | 1602.47 | 0.00 | 0.00 | 782.99 | 819.48 |
| Diaz, Beth, P,21313 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Romero, Kristi, D,16965 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suarez, Monique,17833 | 5999.45 | 0.00 | 0.00 | 3694.47 | 2304.98 |
| She, Mario,11407 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Griffin, Benjamin,13454 | 2344.26 | 0.00 | 0.00 | 0.00 | 2344.26 |
| Ross, Isabella,14292 | 3319.70 | 0.00 | 0.00 | 1000.44 | 2319.26 |
| Garcia, Kristi,18594 | 2325.96 | 0.00 | 0.00 | 0.00 | 2325.96 |
| Flores, Robert,26097 | 5773.04 | 0.00 | 3374.99 | 0.00 | 2398.05 |
| Lu, Vincent,13053 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
Generated 2025-12-24 06:07:06.904 UTC