[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 374 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Young, Julia, J,27414 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Yolanda, C,22154 | 36.96 | 0.00 | 0.00 | 36.96 | 0.00 |
| Ms., Coleman, Abigail, C,23868 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Gutierrez, Linda, D,28575 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sanz, Lori, L,23865 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Alexander, Paige, W,18604 | 59.25 | 0.00 | 0.00 | 0.00 | 59.25 |
| Sharma, Samuel,27725 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Rodriguez, Taylor,16071 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Ramirez, Brian, M,11618 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Turner, Wyatt,20034 | 5769.96 | 0.00 | 3399.99 | 0.00 | 2369.97 |
| Stewart, Amanda, M,15310 | 94.44 | 0.00 | 0.00 | 0.00 | 94.44 |
| Hughes, Luke, I,27014 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Butler, Jonathan,26180 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-22 01:17:02.445 UTC