[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 39 > < TAKE 16 >
16 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rivera, Rachel, S,28996 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Gonzales, Paige,21702 | 91.94 | 0.00 | 0.00 | 0.00 | 91.94 |
| Roberts, Noah, S,27042 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Parker, Natalie, A,25104 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Peterson, Christina,28976 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Moore, Matthew, W,13267 | 109.95 | 0.00 | 0.00 | 0.00 | 109.95 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Hernandez, Jamie,27283 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Hill, Sydney,26482 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Henderson, Isabelle, K,16366 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Russell, Jessica,26572 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Turner, Morgan,11823 | 178.47 | 0.00 | 0.00 | 0.00 | 178.47 |
| Nelson, Jordan, H,20130 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Jones, Madison,24661 | 4181.76 | 0.00 | 3578.27 | 603.49 | 0.00 |
| Williams, Destiny, S,15881 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Sánchez, Angela, C,17655 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
Generated 2025-12-22 16:38:29.561 UTC