[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 30 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Peterson, Melissa, S,24995 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Lewis, Kaitlyn,15906 | 4761.03 | 0.00 | 0.00 | 0.00 | 4761.03 |
| Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 248.38 | 1142.17 |
| Bailey, Richard, N,22050 | 4160.53 | 3578.27 | 0.00 | 0.00 | 582.26 |
| Henderson, Hailey, C,17148 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Watson, Victoria,16125 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Martin, John, A,14436 | 4776.01 | 0.00 | 0.00 | 0.00 | 4776.01 |
| Brooks, Jennifer, L,17411 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Ross, Jose,27441 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Roberts, Amber, W,21582 | 2638.06 | 0.00 | 0.00 | 2049.10 | 588.96 |
| Parker, Morgan, S,16772 | 36.96 | 0.00 | 0.00 | 14.98 | 21.98 |
| Collins, Jose,24748 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Patterson, Jocelyn, D,23559 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ramos, Derrick,18449 | 100.94 | 0.00 | 0.00 | 30.97 | 69.97 |
Generated 2025-11-06 07:43:20.377 UTC