[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 936 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hayes, Jason,26176 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Thompson, Kaitlyn, L,12430 | 223.93 | 0.00 | 0.00 | 0.00 | 223.93 |
| Lewis, Kaitlyn,15906 | 4761.03 | 0.00 | 0.00 | 0.00 | 4761.03 |
| Jones, Kayla, C,18541 | 94.26 | 0.00 | 0.00 | 0.00 | 94.26 |
| Sharma, Samuel,27725 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Richardson, Lauren, C,14867 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| White, Judith, R,14885 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hughes, Edward,20023 | 4530.47 | 0.00 | 3374.99 | 0.00 | 1155.48 |
| Lee, Samantha, B,27378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Foster, Emma,15468 | 436.35 | 0.00 | 0.00 | 0.00 | 436.35 |
| Rogers, Faith,24682 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Johnson, Ian, E,21732 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Patterson, Cassidy, A,17586 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Flores, Xavier,23866 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Flores, Morgan,19817 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Taylor, Marcus, A,18944 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Hughes, Luke, I,27014 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Morgan, Isabella, L,28602 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| King, Sara,22354 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perry, Jonathan, T,27026 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Adams, Julia, N,26073 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Miller, Jill,12914 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Brooks, Lucas, S,16089 | 342.03 | 0.00 | 0.00 | 0.00 | 342.03 |
| Edwards, Hailey,24258 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ross, David, M,17143 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Morgan, Abigail, C,24431 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 |
| Smith, Megan, J,26716 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Sanchez, Rachel, C,26730 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martinez, Hannah, M,24666 | 4370.61 | 0.00 | 3578.27 | 0.00 | 792.34 |
| Sanchez, Caitlin, M,22080 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Hall, Natalie, A,23070 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2026-01-04 05:18:21.256 UTC