[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 281 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Washington, Adam, G,25437 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perez, Barry, M,27282 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Hughes, Luke, I,27014 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Perry, Natalie,17126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Yuan, Brendan, S,24744 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jackson, Joseph, R,23592 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Gray, Marcus, T,18389 | 2401.45 | 0.00 | 0.00 | 0.00 | 2401.45 |
| Mitchell, Caleb, K,26806 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Griffin, Xavier,22877 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Garcia, Anna, B,15572 | 104.55 | 0.00 | 0.00 | 0.00 | 104.55 |
| Price, Marissa,15826 | 160.74 | 0.00 | 0.00 | 120.48 | 40.26 |
| Hall, Jose, J,17601 | 225.42 | 0.00 | 0.00 | 155.45 | 69.97 |
| Kelly, Angel, E,15418 | 232.23 | 0.00 | 0.00 | 0.00 | 232.23 |
| Clark, Joseph, D,15395 | 4780.02 | 0.00 | 0.00 | 0.00 | 4780.02 |
| Rogers, Amanda, A,13920 | 266.97 | 0.00 | 0.00 | 0.00 | 266.97 |
| Stewart, Amanda, M,15310 | 94.44 | 0.00 | 0.00 | 0.00 | 94.44 |
| Carter, Jonathan,14578 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 2325.96 | 2393.06 |
| Hernandez, José, M,11253 | 696.61 | 0.00 | 0.00 | 98.97 | 597.64 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| James, Richard, D,15760 | 109.23 | 0.00 | 0.00 | 3.99 | 105.24 |
| Sanders, Lucas, W,26802 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lee, Emma,16948 | 176.43 | 0.00 | 0.00 | 0.00 | 176.43 |
| Sharma, Kathryn,20740 | 140.94 | 0.00 | 0.00 | 0.00 | 140.94 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
| Miller, Destiny,25157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rodriguez, Anthony, G,23829 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Morgan, Marcus, W,28968 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
Generated 2025-11-04 10:16:03.617 UTC