[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 57 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
| Lewis, Seth,26782 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Flores, Luke, L,24733 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Russell, Katherine,28771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Butler, Trevor,27415 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Garcia, Victoria, V,24501 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Scott, Adam,15863 | 243.01 | 0.00 | 0.00 | 0.00 | 243.01 |
| Thompson, Lucas, O,21277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rodriguez, Anthony, G,23829 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Coleman, Destiny, W,12122 | 4814.04 | 0.00 | 0.00 | 0.00 | 4814.04 |
| Wilson, Grace,17539 | 205.92 | 0.00 | 0.00 | 0.00 | 205.92 |
| Smith, Justin, P,19827 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Srini, Evelyn,16855 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Wilson, Emily,17400 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Hernandez, Jonathan, J,19014 | 65.95 | 0.00 | 0.00 | 0.00 | 65.95 |
Generated 2026-01-04 05:41:31.055 UTC