[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 14 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rogers, Jade, I,14332 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Martin, Lucas, L,22114 | 4183.23 | 0.00 | 3578.27 | 0.00 | 604.96 |
| Baker, Mason, A,13270 | 2394.95 | 0.00 | 0.00 | 0.00 | 2394.95 |
| Jackson, Hannah, G,13143 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
| Lewis, Morgan,17410 | 168.74 | 0.00 | 0.00 | 0.00 | 168.74 |
| Diaz, Gabrielle,14893 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Reed, Marcus,14582 | 111.79 | 0.00 | 0.00 | 0.00 | 111.79 |
| Winston, Ethan, R,21622 | 2612.06 | 0.00 | 0.00 | 2049.10 | 562.96 |
| Hughes, Nathan, B,12113 | 4737.53 | 0.00 | 0.00 | 0.00 | 4737.53 |
| Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 96.07 | 65.21 |
| Adams, Kyle, E,18812 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gray, Cindy, A,13198 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| Bryant, Gabriel,27656 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Russell, Samuel, V,11652 | 310.93 | 0.00 | 0.00 | 0.00 | 310.93 |
| Reed, Michelle,28046 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
Generated 2025-12-23 08:25:18.425 UTC