[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 406 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Campbell, Lucas,29329 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Mitchell, Thomas, J,13711 | 2380.47 | 0.00 | 0.00 | 0.00 | 2380.47 |
| Carter, Katherine,11861 | 286.30 | 0.00 | 0.00 | 0.00 | 286.30 |
| Price, Oscar, G,11833 | 240.01 | 0.00 | 0.00 | 0.00 | 240.01 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 58.47 | 240.02 |
| Green, Marcus, C,15974 | 208.41 | 0.00 | 0.00 | 91.95 | 116.46 |
| Peterson, Xavier, R,26456 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Prasad, Summer, M,22143 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Wilson, Eduardo,15323 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Martinez, Carol, D,17656 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Jai, Jose,12944 | 164.21 | 0.00 | 0.00 | 0.00 | 164.21 |
| Watson, Marcus,22715 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Morgan, Timothy,14633 | 242.50 | 0.00 | 0.00 | 71.58 | 170.92 |
| Smith, Chloe,17619 | 163.92 | 0.00 | 0.00 | 0.00 | 163.92 |
| Griffin, Miguel,21464 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Ramos, Derrick,18449 | 100.94 | 0.00 | 0.00 | 30.97 | 69.97 |
| Martinez, Grace, M,17385 | 208.69 | 0.00 | 0.00 | 69.97 | 138.72 |
| Morris, Jessica,28967 | 8.99 | 0.00 | 0.00 | 8.99 | 0.00 |
| Flores, Isabelle, A,15526 | 188.32 | 0.00 | 0.00 | 96.07 | 92.25 |
| Perez, Savannah, J,17036 | 176.95 | 0.00 | 0.00 | 56.97 | 119.98 |
| Taylor, Tyler, A,12032 | 614.96 | 0.00 | 0.00 | 614.96 | 0.00 |
| Reed, Paige,22112 | 6047.32 | 0.00 | 3578.27 | 2469.05 | 0.00 |
| Richardson, Arianna, C,12055 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Lee, James, J,28817 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Scott, Eric,28248 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Rogers, Andrea, L,14328 | 308.66 | 0.00 | 0.00 | 49.97 | 258.69 |
| Perry, Samuel,18811 | 100.96 | 0.00 | 0.00 | 100.96 | 0.00 |
| Foster, Emma,15468 | 436.35 | 0.00 | 0.00 | 159.99 | 276.36 |
| Harris, Isabella,17119 | 214.90 | 0.00 | 0.00 | 77.96 | 136.94 |
| Turner, James, E,16841 | 126.96 | 0.00 | 0.00 | 69.99 | 56.97 |
Generated 2025-11-06 19:48:10.812 UTC