[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hayes, Jeremiah, W,20086 | 128.55 | 0.00 | 0.00 | 0.00 | 128.55 |
| Flores, Nathan, C,24637 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perry, Natalie,17126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Anderson, Ryan, W,13271 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Bailey, Hailey, R,26270 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Clark, Zachary, J,23893 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Wilson, Nathan, L,13936 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Carter, Savannah, M,12090 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Raje, Mindy, A,16083 | 561.97 | 0.00 | 0.00 | 0.00 | 561.97 |
| Ross, David, M,17143 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Evans, Elijah, S,25884 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Walker, Hunter,27100 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Simmons, David, E,12017 | 2339.97 | 0.00 | 0.00 | 0.00 | 2339.97 |
| Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 73.87 | 1316.68 |
| Watson, Olivia, S,13860 | 93.85 | 0.00 | 0.00 | 14.98 | 78.87 |
Generated 2025-12-23 06:48:01.865 UTC