[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 229 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martin, Madison, C,20492 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Washington, Alexis,19781 | 46.26 | 0.00 | 0.00 | 7.28 | 38.98 |
| Coleman, Luke, A,11723 | 152.55 | 0.00 | 0.00 | 69.98 | 82.57 |
| Miller, Eduardo,14561 | 158.84 | 0.00 | 0.00 | 49.97 | 108.87 |
| Gonzalez, Jordan,15157 | 213.94 | 0.00 | 0.00 | 123.98 | 89.96 |
| Butler, Trevor,27415 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 237.82 | 1067.84 |
| Peterson, Jessica, M,11868 | 247.01 | 0.00 | 0.00 | 61.97 | 185.04 |
| Foster, Antonio,12795 | 108.54 | 0.00 | 0.00 | 66.26 | 42.28 |
| Hill, Alexandra, K,15172 | 215.45 | 0.00 | 0.00 | 36.27 | 179.18 |
| Morgan, Andrea, M,16870 | 149.04 | 0.00 | 0.00 | 116.44 | 32.60 |
| Isla, Julian, A,13732 | 108.96 | 0.00 | 0.00 | 4.99 | 103.97 |
| Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Hall, Natalie, A,23070 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
Generated 2025-11-06 05:08:32.789 UTC