[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 51 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chandra, Darren,20698 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Henderson, Aaron,28762 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Ward, Ariana, V,24956 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Arun, Preston,23784 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Wilson, Joshua, A,28606 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Gutierrez, Mallory,21827 | 2354.98 | 0.00 | 0.00 | 0.00 | 2354.98 |
| Bradley, Chloe, A,13989 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Gray, Melanie, S,20355 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Carlson, Anne, H,22305 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
| Barnes, Abigail,15903 | 1372.95 | 0.00 | 0.00 | 782.99 | 589.96 |
| Hughes, Wyatt, H,26872 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Jenkins, Edward, S,28725 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Generated 2025-12-24 05:53:37.097 UTC