[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 43 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Garcia, Brenda,13574 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Andersen, Dustin, L,26684 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Gonzalez, Gabriel, R,14471 | 3355.43 | 0.00 | 0.00 | 1000.44 | 2354.99 |
| Wright, Ian, P,16903 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Patterson, Madison,17779 | 4250.21 | 0.00 | 0.00 | 1000.44 | 3249.77 |
| Patel, Dominique,13781 | 109.96 | 0.00 | 0.00 | 0.00 | 109.96 |
| Morris, Grace, A,20006 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Rogers, Jeremy, G,19323 | 1584.76 | 0.00 | 0.00 | 782.99 | 801.77 |
| Ward, Jeremy, D,24951 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Xu, Dale,26382 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Li, Gabriel, J,13395 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Peterson, Paige,13754 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Hall, Nicole,26203 | 188.98 | 0.00 | 0.00 | 0.00 | 188.98 |
| Garcia, Janelle,27089 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
Generated 2025-12-22 05:56:28.731 UTC