[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 48 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alvarez, Melody,25070 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Perry, Christian,24671 | 4354.60 | 0.00 | 3578.27 | 0.00 | 776.33 |
| Peterson, Gabrielle, D,24310 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Russell, Rachel, C,21581 | 24.27 | 0.00 | 0.00 | 24.27 | 0.00 |
| Powell, Ian,26085 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Bell, Brooke, H,23253 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Brown, Fernando,19001 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| White, Tyler,14291 | 258.44 | 0.00 | 0.00 | 49.97 | 208.47 |
| Jones, Dalton, T,18951 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Powell, Jordyn, K,15391 | 4828.01 | 0.00 | 0.00 | 0.00 | 4828.01 |
| Roberts, Seth, H,11510 | 258.15 | 0.00 | 0.00 | 0.00 | 258.15 |
| Russell, Nicole, M,18237 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Parker, Eduardo, M,12939 | 169.42 | 0.00 | 0.00 | 0.00 | 169.42 |
| Wilson, Grace,17539 | 205.92 | 0.00 | 0.00 | 0.00 | 205.92 |
| Thames, Bernard,23803 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Sanders, Chloe, C,23137 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Robinson, Madison, W,18377 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 |
| Collins, Lucas, T,21921 | 4142.75 | 0.00 | 3578.27 | 0.00 | 564.48 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Smith, Lucas, P,18090 | 64.91 | 0.00 | 0.00 | 0.00 | 64.91 |
| Green, Blake, P,11719 | 287.20 | 0.00 | 0.00 | 0.00 | 287.20 |
| Hayes, Austin,20208 | 3219.58 | 0.00 | 2049.10 | 0.00 | 1170.48 |
| Russell, Katherine,28771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lal, Jack, R,18525 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Gonzales, Jose,22014 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Murphy, Richard, M,22299 | 4145.54 | 0.00 | 3578.27 | 0.00 | 567.27 |
| Coleman, Lucas, A,27060 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Hall, Jan, M,11740 | 334.12 | 0.00 | 0.00 | 0.00 | 334.12 |
Generated 2025-12-21 17:45:48.601 UTC