[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 45 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Liu, Laura,19998 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Shan, Rafael, A,13219 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 | 0.00 |
| Gonzales, Gabriel, M,13927 | 3021.04 | 0.00 | 0.00 | 2181.56 | 839.48 | 0.00 |
| Butler, Seth,15300 | 4.99 | 0.00 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Chloe,24667 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 | 0.00 |
| Sharma, Terry,14000 | 84.92 | 0.00 | 0.00 | 0.00 | 84.92 | 0.00 |
| Raji, Bonnie,12156 | 5920.24 | 0.00 | 3578.27 | 0.00 | 2341.97 | 0.00 |
| Cooper, Shelby,24740 | 96.07 | 0.00 | 0.00 | 0.00 | 96.07 | 0.00 |
| Powell, Victoria,23016 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 | 0.00 |
| Henderson, Carson,27453 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 | 0.00 |
| Sharma, Tara,24137 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 | 0.00 |
| Parker, Chloe, J,27480 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 | 0.00 |
Generated 2026-01-04 05:37:18.263 UTC