[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Diaz, Jason,17374 | 206.63 | 0.00 | 0.00 | 89.46 | 117.17 |
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Bailey, Lauren,15864 | 103.55 | 0.00 | 0.00 | 9.99 | 93.56 |
| Rogers, Jared, J,12166 | 162.22 | 0.00 | 0.00 | 0.00 | 162.22 |
| Brown, Anna,16247 | 95.82 | 0.00 | 0.00 | 0.00 | 95.82 |
| Coleman, Alexandria, C,13289 | 42.28 | 0.00 | 0.00 | 37.29 | 4.99 |
| Miller, Alexis, A,12196 | 124.93 | 0.00 | 0.00 | 54.96 | 69.97 |
| Moreno, Meredith, D,22285 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 369.40 | 354.16 |
| Morris, Abigail, C,28776 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Flores, Emily,13206 | 163.19 | 0.00 | 0.00 | 69.97 | 93.22 |
| Green, Marcus, C,15974 | 208.41 | 0.00 | 0.00 | 91.95 | 116.46 |
| King, Morgan,19681 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Taylor, Ryan,17025 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Ramirez, Abigail, S,15859 | 74.14 | 0.00 | 0.00 | 24.27 | 49.87 |
| Diaz, Luis, D,11203 | 801.77 | 0.00 | 0.00 | 469.77 | 332.00 |
| Harris, Emily, P,19862 | 98.48 | 0.00 | 0.00 | 4.99 | 93.49 |
| Yang, Jordan, K,14458 | 133.95 | 0.00 | 0.00 | 0.00 | 133.95 |
| Stewart, Jessica,16097 | 103.55 | 0.00 | 0.00 | 46.58 | 56.97 |
| Hernandez, Jonathan, J,19014 | 65.95 | 0.00 | 0.00 | 30.97 | 34.98 |
| Sanchez, Alex, K,13101 | 4736.03 | 0.00 | 0.00 | 2351.96 | 2384.07 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 839.29 | 316.23 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 205.68 | 634.47 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 131.55 | 143.95 |
| Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 155.22 | 496.76 |
| Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 350.91 | 1030.46 |
| Sanchez, Mariah, R,19220 | 66.65 | 0.00 | 0.00 | 38.88 | 27.77 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Generated 2026-07-22 20:35:44.824 UTC